Re: [PERFORM] Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum

Craig Ringer wrote: ### My Issue No. 1: Index Size Is such disk usage for indexes expected? What can I do to optimize? I could not run yet a VACUUM on result_orig, as I hit into max_fsm_pages limit You'll like 8.4 then, as you no longer have to play with max_fsm_pages. The fact that you're hitt

Re: [PERFORM] Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum

On 5/12/2009 7:03 AM, Andreas Thiel wrote: Hi All, Maybe some questions are quite newbie ones, and I did try hard to scan all the articles and documentation, but I did not find a satisfying answer. ### My Issue No. 1: Index Size Is such disk usage for indexes expected? What can I do to optim

Re: [PERFORM] performance while importing a very large data set in to database

On Sat, Dec 5, 2009 at 7:16 AM, "Ing . Marcos Luís Ortíz Valmaseda" wrote: > Ashish Kumar Singh escribió: >> >> Hello Everyone, >> >> >> I have a very bit big database around 15 million in size, and the dump >> file is around 12 GB. >> >> While importing this dump in to database I have noticed tha

Re: [PERFORM] query cost too high, anyway to reduce it

On Fri, Dec 4, 2009 at 3:15 AM, nair rajiv wrote: > We populated the table with data and used EXPLAIN > > > dbpedia=# EXPLAIN   SELECT   nid,max(ssid) FROM gbobjects  where ssid<= > 10  group by nid  ; > >   QUERY PLAN >

Re: [PERFORM] performance while importing a very large data set in to database

On Wed, Dec 2, 2009 at 4:31 PM, Ashish Kumar Singh wrote: > Hello Everyone, > > I have a very bit big database around 15 million in size, and the dump file > is around 12 GB. > > While importing this dump in to database I have noticed that initially query > response time is very slow but it does i

Re: [PERFORM] Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum

On Fri, Dec 4, 2009 at 4:03 PM, Andreas Thiel wrote: > Hi All, > > Maybe some questions are quite newbie ones, and I did try hard to scan > all the articles and documentation, but I did not find a satisfying > answer. > > I'm running PostgreSQL 8.3.6 on a 32-Bit Centos 4 machine (which I > probabl

Re: [PERFORM] performance while importing a very large data set in to database

Ashish Kumar Singh escribió: Hello Everyone, I have a very bit big database around 15 million in size, and the dump file is around 12 GB. While importing this dump in to database I have noticed that initially query response time is very slow but it does improves with time. Any suggesti

Re: [PERFORM] Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum

Hi, On Saturday 05 December 2009 00:03:12 Andreas Thiel wrote: > I'm running PostgreSQL 8.3.6 on a 32-Bit Centos 4 machine (which I > probably should update to 64 Bit soon) How much memory? > I'm going to work on the table size of the largest table (result_orig) > itself by eliminating columns,

Re: [PERFORM] performance while importing a very large data set in to database

On 12/02/2009 11:31 PM, Ashish Kumar Singh wrote: While importing this dump in to database I have noticed that initially query response time is very slow but it does improves with time. Any suggestions to improve performance after dump in imported in to database will be highly appreciated! Ana

[PERFORM] Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum

Hi All, Maybe some questions are quite newbie ones, and I did try hard to scan all the articles and documentation, but I did not find a satisfying answer. I'm running PostgreSQL 8.3.6 on a 32-Bit Centos 4 machine (which I probably should update to 64 Bit soon) I have some tables which tend

[PERFORM] performance while importing a very large data set in to database

Hello Everyone, I have a very bit big database around 15 million in size, and the dump file is around 12 GB. While importing this dump in to database I have noticed that initially query response time is very slow but it does improves with time. Any suggestions to improve performance after dum

[PERFORM] query cost too high, anyway to reduce it

-- TABLE STRUCTURE -- CREATE TABLE gbobjects ( ssid bigint NOT NULL, nid character varying NOT NULL, inid bigint NOT NULL, uid bigint NOT NULL, status character varying, noofchanges integer NOT NULL

[PERFORM] Time Profiling inside the procedure

Hi All, I want to identify the bottleneck queries inside the procedure. I want to know which of the queries are taking the time. How can I measure time taken to execute the individual Query inside a Procedure ? Thank You Niraj Patel From: "pgsql-performance-ow

Re: [PERFORM] OpenMP in PostgreSQL-8.4.0

Sounds more like a school project than a proper performance question. On 11/28/09, Reydan Cankur wrote: > Hi, > > I am trying to run postgresql functions with threads by using OpenMP. > I tried to parallelize slot_deform_tuple function(src/backend/access/ > common/heaptuple.c) and added below lin

Re: [PERFORM] Server Freezing

Perhaps making your select be explicitely part of a read-only transaction rather than letting java make use of an implicit transaction (which may be in auto commit mode) On 11/30/09, Waldomiro wrote: > Hi everybody, > > I have an java application like this: > > while ( true ) { > Thread.slee