Dear all,
I have 2 tables in my database name clause2( 4900 MB) &
page_content(1582 MB).
My table definations are as :
*page_content :-
*CREATE TABLE page_content
(
content_id integer,
wkb_geometry geometry,
link_level integer,
isprocessable integer,
isvalid integer,
isanalyzed integer
On Tue, Mar 22, 2011 at 6:52 PM, 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
> dat
On Fri, Mar 11, 2011 at 10:32 AM, hans wulf 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
> heap scan
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 bloated.
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
"Mahadevan, Mridula" 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 times out(statement timeout is s
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.
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
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 wrote:
> Red Maple wrote:
>
> > Here is my function. If I
On Thu, Mar 17, 2011 at 7:51 PM, Oliver Charles
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 going to be
> buying the hardwa
10 matches
Mail list logo