Skip site navigation (1) Skip section navigation (2)

BUG #4316: 13 seconds to complete SELECT * FROM pg_catalog.pg_attribute

From: "blueos" <blueos(at)free(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4316: 13 seconds to complete SELECT * FROM pg_catalog.pg_attribute
Date: 2008-07-18 09:56:36
Message-ID: 200807180956.m6I9uaSO057150@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4316
Logged by:          blueos
Email address:      blueos(at)free(dot)fr
PostgreSQL version: 8.3.3
Operating system:   Linux
Description:        13 seconds to complete SELECT * FROM 
pg_catalog.pg_attribute
Details: 

On a server with 5 databases (a schema containing 59 tables and 58
sequences),
a SELECT * FROM  pg_catalog.pg_attribute takes 13s to complete.

It returns 4063 lines.

The server is a high end Intel dual core with 4Go of memory, the database is
only about 1MB of data! on this machine, a typical query returns in less
than 60ms.

A strange performance issue.

Regards,
Guillaume

pgsql-bugs by date

Next:From: Dave PageDate: 2008-07-18 11:40:55
Subject: Re: BUG #4312: Installation fails
Previous:From: jspxnetDate: 2008-07-18 08:20:37
Subject: BUG #4315: message encoding is error,not show chinese

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group