On Thu, Mar 17, 2011 at 7:51 PM, Oliver Charles
postgresql-p...@ocharles.org.uk wrote:
Hello,
At MusicBrainz we're looking to get a new database server, and are
hoping to buy this in the next couple of days. I'm mostly a software
guy, but I'm posting this on behalf of Rob, who's actually
Hi,
I have found the bug in my code that made the update to the same row in the
table instead of two different row. Now I have all cores up and running
100%.
Thank you for all your help.
On Fri, Mar 18, 2011 at 3:21 PM, Kevin Grittner kevin.gritt...@wicourts.gov
wrote:
Red Maple
I have a function where in
In a cursor loop I
1. create a temp table (on commit drop)
2. insert data into it
3. Run Analyze on the table
Select/update outside the loop.
This has been running fine for a while on multiple setups, large and small
volumes. The setups all have
Phillippe,
At Bull company, we want to answer a call for tender from a large
company. And we are asked for information about PostgreSQL performance
under AIX on Power 7 servers.
Afilias runs PostgreSQL on AIX. I don't know the architecture, though.
Or what they think of it as a platform.
Mahadevan, Mridula mridula.mahade...@ironmountain.com writes:
This has been running fine for a while on multiple setups, large and small
volumes. The setups all have the same hardware configuration.
On one particular setup with about 200k records and this analyze runs for
45min and then
I posted many weeks ago about a severe problem with a table that was
obviously bloated and was stunningly slow. Up to 70 seconds just to get a
row count on 300k rows.
I removed the text column, so it really was just a few columns of fixed
data.
Still very bloated. Table size was 450M
The advice
On 23/03/11 11:52, felix wrote:
I posted many weeks ago about a severe problem with a table that was
obviously bloated and was stunningly slow. Up to 70 seconds just to get
a row count on 300k rows.
I removed the text column, so it really was just a few columns of fixed
data.
Still very
On Fri, Mar 11, 2011 at 10:32 AM, hans wulf lo...@gmx.net wrote:
I need an ANTI-JOIN (not exists SELECT something from table.../ left join
table WHERE table.id IS NULL) on the same table. Acutally I have an index to
serve the not exists question, but the query planner chooses to to a bitmap