858 reputation
46
bio website
location Amsterdam, The Netherlands
age
visits member for 4 years, 9 months
seen Dec 1 at 11:40

alt text

CTO


Sep
24
awarded  Autobiographer
Mar
6
awarded  Yearling
Mar
6
awarded  Yearling
Dec
1
comment PostgreSQL Page-level locking
PostgreSQL doesn't have page level locking.
Aug
9
awarded  Editor
Aug
9
revised kill -9 a postgres process
Link to the current documentation
Aug
9
suggested approved edit on kill -9 a postgres process
Jul
30
answered Modifiying parameters in postgresql.conf and SIGHUP
May
7
comment postgresql log queries single database
Yes he was wrong, check the manual: postgresql.org/docs/current/interactive/… This setting can be changed by the superuser at any time for any database.
Apr
5
answered postgresql log queries single database
Mar
6
awarded  Yearling
Feb
16
comment Howto dedicate one cpu core to os in PostgreSQL DB server
Are you sure? A single database connection (a.k.a. single database proces), can only use a single core. That means that no query will ever be able to eat up all CPU's/cores.
Oct
22
answered How to install or upgrade to PostgreSQL 8.1 in RHEL 4?
Sep
21
comment Get back the Disk space from Postgresql
Stop all processes on that table on a quiet moment and do a VACUUM FULL. Afterwards, you need a REINDEX for this table as well, VACUUM FULL might inflate your indexes. VACUUM FULL will always disturb other processes, that's why you need auto_vacuum to prevent the need for a VACUUM FULL.
Sep
21
answered Get back the Disk space from Postgresql
Aug
17
comment installing PostGIS PostgreSQL 9.1 on windows
PostgreSQL version 9.1 is still in Beta. If you think the installer is not complete, send a report to the PostgreSQL project.
Aug
10
comment why postgresql doesn't initdb at startup?
This is not a PostgreSQL issue, PostgreSQL doesn't create/maintain the script in init.d for CentOS.
May
31
answered postgres 9 replication - replicating only one database
May
18
answered How many queries per second execute in postgressql database
May
18
answered PostgreSQL 9.0 HA load balancing between servers