7,186 reputation
31740
bio website
location Berlin, Germany
age 39
visits member for 3 years
seen 3 mins ago

Apr
12
comment Is a REINDEX required after CLUSTER?
@TREE there are many feature changes between versions and the docs change (mostly) accordingly. Presumably the specs change also :), so I see no tie anywhere.
Apr
11
comment How to determine if there are [idle connections with] uncommitted transactions in PostgreSQL?
Beware that the state column is present only in 9.2. And for me it looks like the proper state is 'idle in transaction'.
Apr
11
comment How to determine if there are [idle connections with] uncommitted transactions in PostgreSQL?
@MaxVernon there are some hints that it is supposed to work on Windows but haven't seen any concrete example. But it is still a (relatively) simple Perl project, so... And anyway, it works on the pg_stat* views.
Apr
11
comment dead lock when updating
Is it R2 or 'plain' 2008?
Apr
11
comment How to determine if there are [idle connections with] uncommitted transactions in PostgreSQL?
Have a look at pgtop. You may also hunt for rows showing "idle in transaction" in the output of ps aux.
Apr
9
comment disallow SET command in a postgresql server
Could you tell a few words about the scenario? Anyway, I would think about placing the DB into a quite limited virtual machine - or drop the idea completely if the server should perform regardless of the usage of this DB.
Apr
5
comment PostgreSQL Sequential Scan instead of Index Scan Why?
Basically the index scan is quite fast, the problem is that it is repeated a few million times. What do you get if you SET enable_nestloop=off before running the query?
Apr
4
comment Inner join using an array column
@ErwinBrandstetter Ah! this happens if you have nearly all extensions listed in PG docs installed :)
Apr
3
comment Inner join using an array column
@ChrisDutrow what do you mean by this? At least you can create and use such an index in PG 9.0
Mar
27
comment Passing argument in trigger dynamically
You can pass arguments to a trigger, but they are string literals, and since they can only be defined at trigger creation, they can be thought as constants. With these you can modify the trigger behaviour if you use the same procedure with multiple triggers, but (AFAIK) can't achieve anything which you can't achieve by using TG_OP, TG_TABLE_NAME and other variables.
Mar
27
comment How to make postgresql SUM to be more accurate on large amount of floating point data?
I agree - basically, if you really need precise sums and products and whatnot, use numeric instead.
Mar
20
comment Create log file only for my executed queries
possible duplicate of Retrive Log Detail
Mar
19
comment Very slow DELETE in PostgreSQL, workaround?
@jd. You can ALTER TABLE tablename DISABLE TRIGGER ALL; DELETE ...; ALTER TABLE tablename ENABLE TRIGGER ALL;
Mar
19
comment Very slow DELETE in PostgreSQL, workaround?
Is it possible that you have ON DELETE triggers somewhere down the cascading chain?
Mar
13
comment Is there a Postgres admin GUI that can execute a master file containing multiple sql files
OK, then I will be clear: you presumably can't do that in pgAdmin. Anyway, I can't really see why this is a problem (I may be too used to this limitation).
Mar
12
comment Is there a Postgres admin GUI that can execute a master file containing multiple sql files
You can edit your SQL files in any editor (there are much better options than pgAdmin) and then only run a single command in psql (say psql -f master.sql).
Mar
9
comment UPPER Case issue postgreSQL when importing from text file
From this: COPY "hotels" ("","sequence_number"... it looks like that the problem is in the column mapping.
Mar
8
comment UPPER Case issue postgreSQL when importing from text file
Could you present here the first three rows of your file, the error code and maybe the table definition?
Mar
8
comment Export Postgres table on remote server to CSV file on local machine?
@CraigRinger because I'm not used to it, haha :)
Mar
7
comment PostgreSQL user can not connect to server after changing password
Can't one simply set the password again once logged in as postgres?