FAQ

PostgreSQL > pgsql-performance > February 2004

Search Discussions

50 discussions - 331 posts

  • Folks, I've had requests from a couple of businesses to see results of infomal MySQL +InnoDB vs. PostgreSQL tests. I know that we don't have the setup to do full formal benchmarking, but surely ...
    Josh BerkusJosh Berkus
    Feb 2, 2004 at 5:22 pm
    Feb 5, 2004 at 11:09 pm
  • Hi, We have postgres running on freebsd 4.9 with 2 Gigs of memory. As per repeated advice on the mailing lists we configured effective_cache_size = 25520 which you get by doing `sysctl -n ...
    Dror MatalonDror Matalon
    Feb 26, 2004 at 6:03 pm
    Mar 2, 2004 at 8:45 pm
  • Hello, I m checking Postgresql and MS-SQl database server for our new development. On a very first query Postresql is out performed and I think it is very disappointing. My query consists on a single ...
    Saleem Burhani BalochSaleem Burhani Baloch
    Feb 17, 2004 at 6:35 am
    Feb 20, 2004 at 2:34 pm
  • Hi, There alot here, so skip to the middle from my WAL settings if you like. I'm currently investigating the performance on a large database which consumes email designated as SPAM for the perusal of ...
    Rob FieldingRob Fielding
    Feb 28, 2004 at 6:39 pm
    Mar 9, 2004 at 8:27 pm
  • This is a follow-up to an old thread of mine, but I can't find it now so I'll just re-summarize. I have a ~1 million row table that I mostly want to query by date range. The rows are pretty uniformly ...
    John SiracusaJohn Siracusa
    Feb 22, 2004 at 12:18 am
    Feb 24, 2004 at 10:16 pm
  • my data base is very slow. The machine is a processor Xeon 2GB with 256 MB of RAM DDR. My archive of configuration is this: ================================================================ # # ...
    AlemonAlemon
    Feb 11, 2004 at 2:23 pm
    Feb 12, 2004 at 1:27 am
  • I've done some testing of 7.3.4 vs 7.4.1 and found 7.4.1 to be 20%-30% slower than 7.3.4. Is this common knowledge or am I just unlucky with my query/data selection? Things of note that might matter: ...
    Orion HenryOrion Henry
    Feb 5, 2004 at 5:16 am
    Feb 7, 2004 at 7:28 am
  • Hello all. I am in the midst of porting a large web application from a MS SQL Server backend to PostgreSQL. The migration work is basically complete, and we're at the testing and optimization phase ...
    Leon OutLeon Out
    Feb 12, 2004 at 6:30 pm
    Feb 17, 2004 at 3:25 pm
  • Folks, Have an interesting issue with a complex query, where apparently I need to twist the query planner's arm, and am looking for advice on how to do so. The situation: I have a table, events, with ...
    Josh BerkusJosh Berkus
    Feb 19, 2004 at 12:11 am
    Feb 19, 2004 at 9:18 pm
  • To all, This is a 2 question email. First is asking about general tuning of the Apple hardware/postgres combination. The second is whether is is possible to speed up a particular query. PART 1 ...
    Sean ShannySean Shanny
    Feb 20, 2004 at 7:17 pm
    Feb 24, 2004 at 12:54 am
  • I'm trying to join two tables on an inet column, where one of the columns may contain a subnet rather than a single host. Somehow the operation isn't completing quite fast enough, even though neither ...
    Eric JainEric Jain
    Feb 23, 2004 at 11:48 am
    Feb 25, 2004 at 6:35 am
  • Hi, one of our tables has to be updated frequently, but concurrently running SELECT-queries must also have low latency times (it's being accessed through a web interface). I'm looking for ideas that ...
    Marinos J. YannikosMarinos J. Yannikos
    Feb 13, 2004 at 1:01 am
    Feb 16, 2004 at 3:28 am
  • I am running a Dual Xeon hyperthreaded server with 4GB RAM RAID-5. The only thing running on the server is Postgres running under Fedora. I have a 700 connection limit. The DB is setup as a backend ...
    Kevin BarnardKevin Barnard
    Feb 2, 2004 at 7:18 pm
    Feb 3, 2004 at 3:38 pm
  • Hello, Has anyone designed/implemented postgresql server on storage networks? Are there any design considerations? Are there any benchmarks for storage products (HBAs, Switches, Storage Arrays)? Any ...
    Anjan DaveAnjan Dave
    Feb 19, 2004 at 5:01 pm
    Jun 6, 2004 at 10:40 am
  • Hi! Does PostgreSQL allow to create tables and indices of a single database on multiple disk drives with a purpose of increase performance as Oracle database does? If a symbolic reference is the only ...
    Konstantin TokarKonstantin Tokar
    Feb 17, 2004 at 12:54 pm
    Feb 19, 2004 at 4:57 am
  • Hello everyone, I am doing a massive database conversion from MySQL to Postgresql for a company I am working for. This has a few quirks to it that I haven't been able to nail down the answers I need ...
    Kevin CarpenterKevin Carpenter
    Feb 3, 2004 at 4:43 pm
    Feb 3, 2004 at 11:34 pm
  • I sent this to the admin list the other day and got no responses. Maybe this list can give me some pointers. Hello I am working on installing and configuring a Postgres database server. I am running ...
    John AllgoodJohn Allgood
    Feb 26, 2004 at 9:29 pm
    Mar 3, 2004 at 8:46 pm
  • I've written a summary of my findings on implementing and using materialized views in PostgreSQL. I've already deployed eagerly updating materialized views on several views in a production ...
    Jonathan M. GardnerJonathan M. Gardner
    Feb 24, 2004 at 4:11 pm
    Feb 25, 2004 at 3:47 pm
  • Hi we have a table with about 4 million rows. One column has an int value, there is a btree index on it. We tried to execute the following statement and it is very slow on a dual G5 2GHZ with 4 GB of ...
    David TeranDavid Teran
    Feb 11, 2004 at 1:03 pm
    Feb 12, 2004 at 1:54 am
  • I have two tables which have related selection data; they get updated separately. One contains messages, the second an "index key" for each user's viewing history. When I attempt to use a select that ...
    Karl DenningerKarl Denninger
    Feb 6, 2004 at 9:36 pm
    Feb 9, 2004 at 5:34 am
  • Hello, Do you see a way to get better performances with this query which takes currently 655.07 msec to be done. levure= explain analyze SELECT distinct lower(substr(l_name, 1, 1)) AS initiale FROM ...
    Bruno BAGUETTEBruno BAGUETTE
    Feb 6, 2004 at 8:57 am
    Feb 8, 2004 at 5:36 am
  • A 7.3.4 question... I want to "expire" some data after 90 days, but not delete too much at once so as not to overwhelm a system with precariously balanced disk I/O and on a table with millions of ...
    Ed L.Ed L.
    Feb 24, 2004 at 2:11 am
    Feb 24, 2004 at 8:19 pm
  • can anyone tell me what the best way to compile postgresql 7.4.1 on Solaris 9 (UltraSparcIII) is? I have latest gmake and gcc installed. I was going to use CFLAGS="-O2 -fast -mcpu=ultrasparc" based ...
    TeknokratTeknokrat
    Feb 26, 2004 at 12:49 pm
    Mar 11, 2004 at 6:29 pm
  • Hi, I have many indexes somehow overlaping like: ... btree ("STATUS", "VISIBLE", "NP_ID"); ... btree ("STATUS", "VISIBLE"); is perfomance gained by "more exact" index worth overhead with managing ...
    Rigmor UkuheRigmor Ukuhe
    Feb 2, 2004 at 2:47 pm
    Feb 2, 2004 at 7:17 pm
  • Hi, we have a table with about 6.000.000 rows. There is an index on a column with the name id which is an integer and serves as primary key. When we execute select max(id) from theTable; it takes ...
    David TeranDavid Teran
    Feb 16, 2004 at 4:51 pm
    Jun 3, 2004 at 1:07 pm
  • Hi All, I've been seeing very slow read performance on a database of 1 million indexed subscribers, which I believe is nothing to do with the data itself, but delays on processing the index. If I ...
    Damien DouganDamien Dougan
    Feb 5, 2004 at 12:15 pm
    Apr 2, 2004 at 4:44 am
  • I'm converting a SQL application to PostgreSQL. The majority of the logic in this application is in the stored functions in the database. Somewhere, I saw a reference to "WITH (iscachable)" for ...
    Bill MoranBill Moran
    Feb 20, 2004 at 3:35 pm
    Feb 20, 2004 at 4:48 pm
  • Hi All, I'm really like this list. Thank you for all the invaluable information! May I ask a question? I've got a table with about 8 million rows and growing. I must run reports daily off this table, ...
    Todd FultonTodd Fulton
    Feb 17, 2004 at 5:07 pm
    Feb 17, 2004 at 11:55 pm
  • Hi, we are trying to speed up a database which has about 3 GB of data. The server has 8 GB RAM and we wonder how we can ensure that the whole DB is read into RAM. We hope that this will speed up some ...
    David TeranDavid Teran
    Feb 3, 2004 at 12:54 pm
    Feb 4, 2004 at 10:44 pm
  • Hello, I would like to know whether there are any significant performance advantages of compiling (say, 7.4) on your platform (being RH7.3, 8, and 9.0, and Fedora especially) versus getting the ...
    Anjan DaveAnjan Dave
    Feb 3, 2004 at 10:21 pm
    Feb 4, 2004 at 4:30 pm
  • Hi everybody, i'd like to know if it exists a system of cache for the results of queries. What i'd like to do : select whatever_things from (selection_in_cache) where special_conditions; The ...
    David PradierDavid Pradier
    Feb 26, 2004 at 1:25 pm
    Feb 27, 2004 at 12:49 am
  • I can't get the following statement to complete with reasonable time. I've had it running for over ten hours without getting anywhere. I suspect (hope) there may be a better way to accomplish what ...
    Eric JainEric Jain
    Feb 17, 2004 at 12:38 pm
    Feb 18, 2004 at 7:12 pm
  • hello i have postgres 7.3.2.,linux redhat 9.0 a database,and 20 tables a lot of fields are char(x) when i have to make update for all the fields except index postgres works verry hard what should ...
    Stefan bogdanStefan bogdan
    Feb 11, 2004 at 2:01 pm
    Feb 11, 2004 at 4:44 pm
  • Hi! I'd like to know if this is expected behavior. These are two couples of queries. In each couple, the first one has a WHERE field = function() condition, just like the second one, but in the form ...
    Octavio AlvarezOctavio Alvarez
    Feb 6, 2004 at 7:18 am
    Feb 6, 2004 at 2:55 pm
  • Hi, I have a quick question. In order to speed up insertion of large number of rows (100s of thousands) I replaced the INSERT with the COPY. This works fine but one question popped into my mind. Does ...
    Slavisa GaricSlavisa Garic
    Feb 6, 2004 at 2:31 am
    Feb 6, 2004 at 3:21 am
  • Hello i've read in the docs to use the proper indexes both types must match in the where clause, to achive this the user can simply put a string into the side of the equation mark and pgsql will ...
    Czuczy GergelyCzuczy Gergely
    Feb 3, 2004 at 7:25 am
    Feb 3, 2004 at 3:27 pm
  • All three tables have the same integer key, and it's indexed. I parenthesized the joins to do the two small tables first. I'm running and INSERT INTO ... SELECT query with this join (one record added ...
    Andrew LazarusAndrew Lazarus
    Feb 18, 2004 at 10:53 pm
    Feb 23, 2004 at 8:01 pm
  • We have a large (several million row) table with a field containing URLs. Now, funny thing about URLs: they mostly start with a common substring ("http://www."). But not all the rows start with this, ...
    Jeff BoesJeff Boes
    Feb 18, 2004 at 3:25 pm
    Feb 19, 2004 at 8:58 pm
  • It seems, that if I know the type and frequency of the queries a database will be seeing, I could split the database by hand over multiple disks and get better performance that I would with a RAID ...
    Mike GloverMike Glover
    Feb 17, 2004 at 9:54 pm
    Feb 17, 2004 at 10:35 pm
  • We are suddenly getting slow queries on a particular table. Explain shows a sequential scan. We have "vacuum analyze" ed the table. Any hints? Many TIA! Mark testdb=# \d bigtable Table ...
    Mark HarrisonMark Harrison
    Feb 4, 2004 at 10:55 pm
    Feb 5, 2004 at 5:31 pm
  • I have a query that I think should run faster. The machine is P2/400 with enough ram (384MB), but still, maybe the query could be tuned up. postgresql.conf is stock with these values changed: ...
    Ivan VorasIvan Voras
    Feb 24, 2004 at 1:20 pm
    Mar 1, 2004 at 4:41 pm
  • Hi, what is the most performant way to select for example the first 99 rows of a table and insert them into another table... at the moment i do this: for userrecord in select * from table where ...
    PostgresPostgres
    Feb 27, 2004 at 5:10 pm
    Feb 27, 2004 at 7:47 pm
  • Hey All, I've implemented a couple of functions ala date_trunc (listed at the bottom). These functions are executed every 5 minutes (date_trunc_minute) and every week (date_trunc_week) across 16 ...
    Robert CreagerRobert Creager
    Feb 25, 2004 at 5:11 am
    Feb 25, 2004 at 6:05 am
  • Is there a way to automatically coerce an int into a bigint for indexing purposes? We have a table with a bigint column that is an index. For mi, there's no problem, since I now know to say select * ...
    Mark HarrisonMark Harrison
    Feb 11, 2004 at 10:38 pm
    Feb 11, 2004 at 11:24 pm
  • I have a table which has e.g. CREATE TABLE portstats ( id serial, logtime TIMESTAMP, cluster VARCHAR(40), element VARCHAR(40), port INT, rxOctets BIGINT, txOctets BIGINT ); which is used for logging ...
    Don BowmanDon Bowman
    Feb 21, 2004 at 9:12 pm
    Feb 21, 2004 at 9:12 pm
  • This discussion really belongs on the performance list and I am copying that list with mail-followup-to set. On Fri, Feb 20, 2004 at 12:26:22 +0530, V Chitra wrote: Have you analyzed the databases ...
    Bruno Wolff IIIBruno Wolff III
    Feb 20, 2004 at 8:09 pm
    Feb 20, 2004 at 8:09 pm
  • Greetings! Why does creation of gist indexes takes significantly more time than normal btree index. Can any configuration changes lead to faster index creation? query: CREATE INDEX co_name_index_idx ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Feb 14, 2004 at 3:38 am
    Feb 14, 2004 at 3:38 am
  • Hello again. I'm setting up a backup routine for my new db server. As part of my testing, I'm attempting to pg_restore a pg_dump'ed backup of my database. The database is about 4.3 GB, and the dump ...
    Leon OutLeon Out
    Feb 13, 2004 at 9:03 pm
    Feb 13, 2004 at 9:03 pm
  • Quick Question, The full query listed in pg_stat_activity is getting truncated. Does anyone know how I can see the full query in progress? -- Orion Henry <[email protected]
    Orion HenryOrion Henry
    Feb 2, 2004 at 7:27 pm
    Feb 2, 2004 at 7:27 pm
  • Folks, Is anyone on this list using PostgreSQL on a mini or mainframe platform? If so, drop me a line. Thanks! -- -Josh Berkus Aglio Database Solutions San Francisco
    Josh BerkusJosh Berkus
    Feb 2, 2004 at 6:07 pm
    Feb 2, 2004 at 6:07 pm
Feb 2004
Group Navigation
period‹ prev | Feb 2004 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions50
posts331
users98
websitepostgresql.org
irc#postgresql

98 users for February 2004

Tom Lane: 30 posts Josh Berkus: 29 posts Scott.marlowe: 27 posts Christopher Kings-Lynne: 14 posts Richard Huxton: 13 posts Chris Browne: 8 posts Bill Moran: 7 posts Stephan Szabo: 7 posts Dror Matalon: 6 posts Orion Henry: 6 posts PC Drew: 6 posts David Teran: 5 posts Eric Jain: 5 posts Sean Shanny: 5 posts Shridhar Daithankar: 5 posts Alemon: 4 posts Bruno BAGUETTE: 4 posts Jeff: 4 posts John Siracusa: 4 posts Karl Denninger: 4 posts
show more
Archives