Reputation
8,164
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
3 18 43
Newest
 Informed
Impact
~376k people reached

May
11
comment Postgresql performance issues when issuing many small inserts and updates one at a time
How your setup does look like? Are the two servers on the same machine? VMs involved? What sort of disks are there? And what do you see when you monitor the DB activity during the update/insert time?
May
11
comment Put Postgres query result in array
I've just made a small test where I see the two producing the exact same query plan, therefore the same execution time.
May
11
comment Combining separate ranges into largest possible contiguous ranges
@ErwinBrandstetter yes, that's an issue I wanted to test (after my first extreme was 9999-12-31 :). At the same time, I am wondering why my answer has more upvotes than yours. This is possibly easier to understand... So, future voters: Erwin's answer is superior to mine! Vote there!
May
10
comment Postgres automatic insert time stamp with time zone (india)
@0x54MUR41 You don't have to be sorry. If every first-time poster spent this much energy on their post, this site would be even awesomer :) You see, you got some nice upvotes for a reason.
May
10
comment Speed up SELECT with WINDOW, (PARTITION … ORDER) with compound index
Is this an actual problem? The query runs in under a millisecond...
May
9
comment Combining separate ranges into largest possible contiguous ranges
@ErwinBrandstetter that won't really work with generate_series() :)
May
9
comment Postgres automatic insert time stamp with time zone (india)
With which part do you have the problem? What sort of query do you want to insert? Are your servers have proper time zone settings? And finally, what do you mean by desired time format?
May
9
comment Postgres automatic insert time stamp with time zone (india)
I think you slightly overthought the problem - in my understanding, they just want to have a timestamp with every row inserted.
May
8
comment what is causing Errors running from Localhost
Some formatting and a description of what you are actually doing would be more than welcome.
May
8
comment Combining separate ranges into largest possible contiguous ranges
How many different values do you (plan to) have?
May
8
comment Can't list users - “select * from user” returns only one row with one column
This is not really correct, see the output of \dt *."user". Regardless, I'd suggest removing this question in favour of the SO one (with an excellent answer).
May
8
comment Can you force pgpool to require SSL connections?
As far as I can tell from looking at the docs, this is not possible (though it would make sense).
May
8
comment Is it possible to set a timer for autovacuum in PostgreSQL
Please confirm that it is the autovacuum that blovks your access - this is not supposed to be so, the workers give way to allow other activities. Set up some monitoring and watch what happens at that time. You can choose something from here: wiki.postgresql.org/wiki/Monitoring, I recommend pg_view as it was developed by my colleagues.
May
7
comment postgres fetch record from partitions without the check constraints
Could you add an example of the situation, with a few rows only? I am still a bit confused about the requirements.
May
7
comment postgresql - granting schema to users
Partly yes, see my edit.
May
7
comment Put Postgres query result in array
I feel array_agg() is a bit more convenient, no need to use a subquery, for example.
May
6
comment Unknown returned type in PostgreSQL query
BTW, did you have a look at executemany()?
May
6
comment How to run pg_bulkload on windows?
Then I understand why you are concerned about time :)
May
6
comment How to run pg_bulkload on windows?
How much data do you import normally (in number of rows and/or physical size)? On an other note, if it crashes your server than you don't get too far with the time spared on the load.
May
6
comment How to run pg_bulkload on windows?
From what I see on the project page, this product is not extremely stable (see the notes about 3.1.7). Are you sure the regular COPY functionality is not enough for you?