Re: [PERFORM] Scaling 10 million records in PostgreSQL table

On 2012-10-08 10:26, Navaneethan R wrote: Hi all, I have 10 million records in my postgres table.I am running the database in amazon ec2 medium instance. I need to access the last week data from the table. It takes huge time to process the simple query.So, i throws time out exception err

Re: [PERFORM] Database-wide VACUUM ANALYZE

And it can be controlled from /etc/periodic.conf See the top of that script. LER Steve -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: [EMAIL PROTECTED] US Mail: 430 Valona Loop, Round Rock, TX 7868

Re: [ADMIN] [PERFORM] autovacuum on a -mostly- r/o table

f the END of the vacuum / analyze. (I'm the author of the patch). -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 ---(end of broadcast)--

Re: [PERFORM] Temporary table

T is it's own transaction. Stick a BEGIN; before the create table, and a commit; after the select. Larry Rosenman > > > > Tks, > > Franklin > > > ---(end of > broadcast)--- TIP 6: explain analyze is y

Re: [PERFORM] Getting even more insert performance (250m+rows/day)

Daniel J. Luke wrote: > On May 24, 2006, at 4:12 PM, Larry Rosenman wrote: >> are the batches single insert's, or within a big transaction? >> If the former, the latter is a big win. > > One big transaction every 5 minutes using 'COPY FROM' (instead of > in

Re: [PERFORM] Getting even more insert performance (250m+rows/day)

does the inserts look like: INSERT INSERT INSERT or BEGIN INSERT INSERT INSERT COMMIT If the former, the latter is a big win. Also, what release(s) are you running? LER -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3

Re: [PERFORM] Autovacuum / full vacuum

e reason is that the system needs to LOOK at the pages/tuples to see if the tuples are dead or not. So, the number of dead tuples impacts the scans. LER > > Mike -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 7

Re: [PERFORM] Feature request: smarter use of conditional indexes

ELECT * FROM t1 WHERE c1 = 123; I'd like the planner to be smart enough to use an index scan using i1. Send a patch ;-) Just a suggestion, please use diff -c format, as it makes it easier for the folks who apply the patches to do so. [snip] -- Larry Rosenman http://ww

Re: [PERFORM] Postgres on Netapp

the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812

Re: [PERFORM] autovacuum daemon stops doing work after about an

ff); diff = ((long long)now.tv_sec - (long long)then.tv_sec) * 100 + (now.tv_usec - then.tv_usec); printf ("long long diff = %lld\n",diff); exit(0); } --cut here-- ---(end of broadcast)--- TIP 2: you can get off all lists at once wi

Re: [PERFORM] reindex/vacuum locking/performance?

ne one that's common across more than one platform :-( I think Verita's VxFS has this as an option/IOCTL. You can read the Veritas doc on my http://www.lerctr.org:8458/ pages under filesystems. That should work on UnixWare and Solaris sites that have VxFS installed. VxFS is st

Re: [PERFORM] opinion on RAID choice

r. As near as I can tell, you do _not_ want to use RAID 5 with Veritas. Out of curiosity, why? I have Veritas Doc up (since UnixWare has it) at: http://www.lerctr.org:8458/en/Navpages/FShome.html if anyone wants to read. LER A -- Larry Rosenman http://www.lerctr.org/~ler