FAQ

PostgreSQL > pgsql-performance > May 2004

Search Discussions

37 discussions - 223 posts

  • Hi, I am curious if there are any real life production quad processor setups running postgresql out there. Since postgresql lacks a proper replication/cluster solution, we have to buy a bigger ...
    Björn MetzdorfBjörn Metzdorf
    May 11, 2004 at 7:07 pm
    May 19, 2004 at 3:38 am
  • My company is developing a PostgreSQL application. We're using 7.3.4 but will soon upgrade to 7.4.x. Our OS is RedHat 9. Our production machines have 512 MB RAM and IDE disks. So far we've been using ...
    JaoJao
    May 10, 2004 at 6:54 pm
    May 12, 2004 at 7:29 pm
  • Hello, I have the following problem: When I run some query after I just run the Postmaster, it takse several seconds to execute (sometimes more than 10), if I rerun it again afterwards, it takes mere ...
    Vitaly BelmanVitaly Belman
    May 21, 2004 at 2:42 pm
    May 27, 2004 at 1:56 pm
  • Hello all, What's the case of bigger database PostgreSQL (so greate and amount of registers) that they know??? Thanks, Carlos Eduardo Smanioto
    Carlos Eduardo SmaniotoCarlos Eduardo Smanioto
    May 5, 2004 at 6:58 pm
    May 7, 2004 at 11:47 pm
  • All, I have a particularly troublesome table in my 7.3.4 database. It typically has less than 50k rows, and a usage pattern of about 1k INSERTs, 50-100k UPDATEs, and no DELETEs per day. It is ...
    Bill MontgomeryBill Montgomery
    May 21, 2004 at 6:50 pm
    May 24, 2004 at 7:08 pm
  • Hello for all! I have PostgreSQL 7.4 under last version of Cygwin and have some problems with performance :( It is very strange... I don't remember this problem on previous version Cygwin and ...
    Eugeny BalakhonovEugeny Balakhonov
    May 19, 2004 at 8:07 pm
    May 20, 2004 at 4:57 pm
  • Hi, at first, many thanks for your valuable replies. On my quest for the ultimate hardware platform I'll try to summarize the things I learned. ...
    Björn MetzdorfBjörn Metzdorf
    May 12, 2004 at 10:41 pm
    May 14, 2004 at 10:15 am
  • I will soon have at my disposal a new IBM pSeries server. The main mission for this box will be to serve several pg databases. I have ordered 8GB of RAM and want to learn the best way to tune pg and ...
    Dan HarrisDan Harris
    May 21, 2004 at 11:23 pm
    May 26, 2004 at 5:21 pm
  • Hi everybody.. Before anything else I would like to thank all those person who answers my previous question. again thank you very much This is my question . In my query .. Select * from table1 where ...
    Michael Ryan S. PunciaMichael Ryan S. Puncia
    May 12, 2004 at 6:11 am
    May 19, 2004 at 3:19 am
  • Hello, I've been having some performance issues with a DB I use. I'm trying to come up with some performance recommendations to send to the "adminstrator". Hardware: CPU0: Pentium III (Coppermine) ...
    Doug YDoug Y
    May 11, 2004 at 10:02 pm
    May 13, 2004 at 8:28 pm
  • Hi. I´m new here and i´m not sure if this is the right email to solve my problem. Well, i have a very large database, with vary tables and very registers. Every day, too many operations are perfomed ...
    Anderson Boechat LopesAnderson Boechat Lopes
    May 10, 2004 at 2:00 pm
    May 10, 2004 at 8:00 pm
  • All tables are vacumed and analyzed . I try so set statistics to 1000 to tag_id columns with ALTER TABLE SET STATISTIC, revacuum analyze , but the planner choose the same query plan . I'm trying now ...
    Fabio PanizzuttiFabio Panizzutti
    May 14, 2004 at 8:30 am
    May 14, 2004 at 10:20 am
  • Hello I'm tuning a postgresql (7.4.2) server for best performance . I have a question about the planner . I have two identical tables : one stores short data (about 2.000.000 record now) and the ...
    Fabio PanizzuttiFabio Panizzutti
    May 13, 2004 at 12:33 pm
    May 13, 2004 at 3:16 pm
  • Hi, I am a newbie here and just starting to use postgresql. My problems is how to tune up my server because it its too slow. We just ported from DBF to postgresql. This is my PC specs: P4, 512Ram, ...
    Michael Ryan S. PunciaMichael Ryan S. Puncia
    May 7, 2004 at 10:58 am
    May 10, 2004 at 8:47 pm
  • From PG http://developer.postgresql.org/docs/postgres/diskusage.html: "(Remember, relpages is only updated by VACUUM and ANALYZE.)" --- Litao Wu wrote:
    Litao WuLitao Wu
    May 24, 2004 at 5:21 pm
    May 25, 2004 at 1:22 am
  • Hi folks, I need some help in a TPCH 100GB benchmark. I described our settings in: http://archives.postgresql.org/pgsql-performance/2004-04/msg00377.php Some queries are taking to long to finish (4, ...
    Eduardo AlmeidaEduardo Almeida
    May 14, 2004 at 6:12 pm
    May 18, 2004 at 12:49 pm
  • I have a big table with some int fields. I frequently need to do queries like: SELECT if2, count(*) FROM table WHERE if1 = 20 GROUP BY if2; The problem is that this is slow and frequently requires a ...
    Joseph ShraibmanJoseph Shraibman
    May 4, 2004 at 2:46 am
    May 4, 2004 at 6:15 pm
  • I wanted to solicit some opinions on architecture and performance from you guys. I am torn right now between these two systems to replace my aging DB server: 4 x 2.2 GHz Opteron 8GB RAM Ultra320 ...
    Dan HarrisDan Harris
    May 27, 2004 at 10:41 pm
    Jun 2, 2004 at 8:17 pm
  • Hi! Thanks ;-) Right, raw partitions are too low-level for me these days anyhow... I assume that all postgres partitions can be mounted with noatime? Does that mean only the xlog, or also the clog? ...
    Share-postgresShare-postgres
    May 22, 2004 at 4:59 am
    May 29, 2004 at 6:31 pm
  • Hello, (note best viewed in fixed-width font) I'm still trying to find where my performance bottle neck is... I have 4G ram, PG 7.3.4 shared_buffers = 75000 effective_cache_size = 75000 Run a query ...
    Doug YDoug Y
    May 18, 2004 at 6:43 pm
    May 25, 2004 at 9:08 pm
  • Hi Guys, My question is .. which is better design 1. Single Table with 50 million records or 2. Multiple Table using inheritance to the parents table I will use this only for query purpose .. Thanks ...
    Michael Ryan S. PunciaMichael Ryan S. Puncia
    May 19, 2004 at 7:31 am
    May 20, 2004 at 9:28 am
  • Hi all, i have a question, is there any advantages in using numeric(1) or numeric(2) in place of smallint? is there any diff. in performance if i use smallint in place of integer? Thanx in advance, ...
    Jaime CasanovaJaime Casanova
    May 14, 2004 at 9:08 pm
    May 16, 2004 at 5:13 pm
  • Hi, I test a configuration where one table is divided in 256 sub-table. And I use a RULE to offer a single view to the data. For INSERT I have create 256 rules like: CREATE RULE ndicti_000 AS ON ...
    Pailloncy Jean-GérardPailloncy Jean-Gérard
    May 3, 2004 at 8:58 pm
    May 6, 2004 at 6:11 pm
  • Hello all, We are using Postgres 7.3 with JBoss 3.2.3 on a Linux Fedora 1.0 box. When I am looking at CPU activity with "top", I often see something like: PID USER PRI NI SIZE RSS SHARE STAT %CPU ...
    Cyrille BonnetCyrille Bonnet
    May 4, 2004 at 11:35 pm
    May 5, 2004 at 6:13 pm
  • Back in 2001, there was a lengthy thread on the PG Hackers list about PG and journaling file systems (http://archives.postgresql.org/pgsql-hackers/2001-05/msg00017.php), but there was no decisive ...
    James ThorntonJames Thornton
    May 2, 2004 at 8:10 am
    May 4, 2004 at 7:38 pm
  • I can't understand what's going on in this simple query: select c.name from Candidate C where C.candidate_id in (select candidate_id from REFERRAL R where r.employee_id = 3000); Where ...
    Josh SacksJosh Sacks
    May 25, 2004 at 6:38 pm
    May 29, 2004 at 5:06 am
  • Mario, Start with reading this: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html Without knowing anything about the size of your database, your usage patterns, or your disk subsystem (the ...
    Bill MontgomeryBill Montgomery
    May 26, 2004 at 4:26 pm
    May 26, 2004 at 4:39 pm
  • All, Does PG store when a table was last analyzed? Thanks,
    Litao WuLitao Wu
    May 18, 2004 at 9:30 pm
    May 26, 2004 at 1:29 pm
  • Hi, How can I automatically kill a process in the database (ex a select or explain) if it exceeds my limit of 2 or 3 mins .. For example : I have a query that already running for 3 or 4 mins I want ...
    Michael Ryan S. PunciaMichael Ryan S. Puncia
    May 25, 2004 at 2:50 am
    May 25, 2004 at 3:00 am
  • I'm working on a project using PostgreSQL as our database designing a budget system. We are still in the design and testing phases but I thought I would ask advice about a platform to host this ...
    Duane Lee - EGOVXDuane Lee - EGOVX
    May 17, 2004 at 11:08 pm
    May 20, 2004 at 1:46 pm
  • Hi All, We have a Postgres 7.4.1 server running on FreeBSD 5.2. Hardware is a Dual Xeon 2.6 (HT enabled), 2 GB Memory, 3Ware SATA RAID-5 w/ 4 7200 RPM Seagate disks and gigabit Intel Server Ethernet. ...
    Jason CoeneJason Coene
    May 11, 2004 at 10:10 pm
    May 12, 2004 at 1:04 am
  • Hi, I have query: select pg_stat_get_numscans(76529669), pg_stat_get_blocks_fetched(76529669), pg_stat_get_blocks_hit(76529669); The result is: pg_stat_get_numscans | pg_stat_get_blocks_fetched | ...
    Litao WuLitao Wu
    May 4, 2004 at 6:44 pm
    May 6, 2004 at 3:45 pm
  • Hai all, I want to log my queries send to the Postgresql server. I heard that we can do this my specifying the file name in /etc/rc.d/init.d/Postgresql initiating file. But I don't know. If this is ...
    RajaguruRajaguru
    May 29, 2004 at 7:04 am
    May 29, 2004 at 7:04 am
  • See http://kerneltrap.org/node/view/3148, about 40% down, under the header "2.6 -aa patchset, object-based reverse mapping". Does this mean that the more shared memory the bigger the potential for a ...
    Joseph ShraibmanJoseph Shraibman
    May 19, 2004 at 7:49 pm
    May 19, 2004 at 7:49 pm
  • ...and on Thu, Apr 22, 2004 at 06:59:10AM -0700, Eduardo Almeida used the keyboard: <snip As I mentioned, that is true for the 1.4.x release of the JVMs. We have been testing some JCA builds of 1.5.0 ...
    Grega BremecGrega Bremec
    May 6, 2004 at 8:59 am
    May 6, 2004 at 8:59 am
  • I mentioned this at the tail end of a long post in another thread, but I have been researching how to configure Postgres for a RAID 10 SAME configuration as described in the Oracle paper "Optimal ...
    James ThorntonJames Thornton
    May 4, 2004 at 7:33 pm
    May 4, 2004 at 7:33 pm
  • You didn't provide your postgres version or an explain analyze so it is hard to answer your question definitivly. Most likely you are using a pre 7.4 version which is know to be slow for IN (which is ...
    Bruno Wolff IIIBruno Wolff III
    May 4, 2004 at 4:32 pm
    May 4, 2004 at 4:32 pm
May 2004
Group Navigation
period‹ prev | May 2004 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions37
posts223
users68
websitepostgresql.org
irc#postgresql

68 users for May 2004

Tom Lane: 19 posts Scott.marlowe: 14 posts Björn Metzdorf: 9 posts Bruce Momjian: 8 posts Chris Browne: 7 posts James Thornton: 7 posts Joseph Shraibman: 7 posts Christopher Kings-Lynne: 6 posts Fabio Panizzutti: 6 posts Litao Wu: 6 posts Michael Ryan S. Puncia: 6 posts Paul Tuckfield: 6 posts Vitaly Belman: 6 posts Marty Scholes: 5 posts Neil Conway: 5 posts Robert Creager: 5 posts Shridhar Daithankar: 5 posts Jack Orenstein: 4 posts Josh Berkus: 4 posts Mark Kirkwood: 4 posts
show more
Archives