FAQ

Search Discussions

59 discussions - 354 posts

  • I recall a reference on the list indicating that newer Xeon processors don't suffer from the context switching problem reported last year. In searching the archives, I can't find any specific info ...
    GeoffreyGeoffrey
    Feb 23, 2007 at 7:06 pm
    Mar 5, 2007 at 1:23 pm
  • I am trying to do fairly simple joins on climate databases that should return ~ 7 million rows of data. However, I'm getting an error message on a OS X (10.4 tiger server) machine that seems to imply ...
    Kirk WythersKirk Wythers
    Feb 2, 2007 at 2:35 pm
    Feb 5, 2007 at 5:50 pm
  • Greetings, Since upgrading to 8.2.3 yesterday, the stats collector process has had very high CPU utilization; it is consuming roughly 80-90% of one CPU. The server seems a lot more sluggish than it ...
    Benjamin MinshallBenjamin Minshall
    Feb 8, 2007 at 4:48 pm
    Mar 2, 2007 at 11:28 pm
  • Hi all, I am asking in this list because, at the end of the day, this is a performance question. I am looking at writing a search engine of sorts for my database. I have only ever written very simple ...
    Madison KellyMadison Kelly
    Feb 26, 2007 at 4:41 pm
    Feb 28, 2007 at 12:40 pm
  • I have a pl/pgsql function that is inserting 200,000 records for testing purposes. What is the expected time frame for this operation on a pc with 1/2 a gig of ram and a 7200 RPM disk? The processor ...
    Karen HillKaren Hill
    Feb 6, 2007 at 12:36 am
    Feb 14, 2007 at 10:24 pm
  • Hello, I'm using geo_distance() from contrib/earthdistance would like to find a way to spend up the geo distance calculation if possible. This is for a proximity search: "Show me adoptable pets ...
    Mark StosbergMark Stosberg
    Feb 3, 2007 at 7:01 pm
    Feb 7, 2007 at 9:31 pm
  • With the help of some of this list, I was able to successfully set up and benchmark a cube-based replacement for geo_distance() calculations. On a development box, the cube-based variations ...
    Mark StosbergMark Stosberg
    Feb 9, 2007 at 7:26 pm
    Feb 16, 2007 at 7:26 pm
  • Dear all, After many tests and doc reading, i finally try to get help from you... Here is my problem. With some heavy insert into a simple BD (one table, no indexes) i can't get better perf than 8000 ...
    HatmanHatman
    Feb 27, 2007 at 5:10 pm
    Mar 6, 2007 at 5:48 pm
  • Thought I'd pass this along, since the Linux vs FreeBSD performance question comes up fairly regularly... BTW, I've already asked about benchmarking with PostgreSQL, so please don't go over there ...
    Jim C. NasbyJim C. Nasby
    Feb 27, 2007 at 6:26 pm
    Mar 7, 2007 at 6:49 pm
  • We have been running Postgres on a 2U server with 2 disks configured in raid 1 for the os and logs and 4 disks configured in raid 10 for the data. I have since been told raid 5 would have been a ...
    Joe UhlJoe Uhl
    Feb 27, 2007 at 1:33 pm
    Mar 6, 2007 at 1:32 am
  • Hi List, I want to run a Select Query on a table. But i dont want the query to pick a index defined on that table. So can i instruct the planner not to pick that index. -- Regards Gauri
    Gauri KanekarGauri Kanekar
    Feb 16, 2007 at 1:59 pm
    Feb 16, 2007 at 7:28 pm
  • I'm needing help determining the best all-around query for the following situation. I have primary table that holds ip information and two other tables that hold event data for the specific IP in ...
    Michael ArtzMichael Artz
    Feb 1, 2007 at 4:42 pm
    Feb 2, 2007 at 9:51 am
  • Hi all, I'm currently working on optimizing a couple of queries. While studying the EXPLAIN ANALYZE output of a query, I found this Bitmap Heap Scan node: - Bitmap Heap Scan on lieu l ...
    Guillaume SmetGuillaume Smet
    Feb 13, 2007 at 4:33 pm
    Feb 16, 2007 at 12:32 am
  • I am about to pull the trigger on a new machine after analyzing some discussions I posted here last year. I've been trying to spec out a reliable and powerfull enough machine where I won't have to ...
    Kenji MorishigeKenji Morishige
    Feb 13, 2007 at 8:15 pm
    Feb 14, 2007 at 6:43 pm
  • As the subject says. A quite puzzling situation: we not only upgraded the software, but also the hardware: Old system: PG 7.4.x on Red Hat 9 (yes, it's not a mistake!!!) P4 HT 3GHz with 1GB of RAM ...
    Carlos MorenoCarlos Moreno
    Feb 28, 2007 at 5:05 pm
    Mar 3, 2007 at 6:41 am
  • When I upgraded a busy database system to PostgreSQL 8.1, I was excited about AutoVacuum, and promptly enabled it, and turned off the daily vacuum process. ( I set the following, as well as the ...
    Mark StosbergMark Stosberg
    Feb 21, 2007 at 6:37 pm
    Feb 23, 2007 at 5:37 pm
  • Hi, I'm running a web application using Zope that obtains all data from a PostgreSQL 7.4 database (Debian Sarge system with package 7.4.7-6sarge4 on an "older" Sparc machine, equipped with 2GB memory ...
    Andreas TilleAndreas Tille
    Feb 19, 2007 at 11:00 am
    Feb 21, 2007 at 5:50 pm
  • Hello All, I'm a performance engineer, quite interested in getting deep into the PGSQL performance enhancement effort. In that regard, I have the following questions : 1. Is there a benchmarking ...
    Krishna KumarKrishna Kumar
    Feb 14, 2007 at 10:00 am
    Feb 16, 2007 at 1:38 pm
  • Hello, I've set up 2 identical machines, hp server 1ghz p3, 768mb ram, 18gb scsi3 drive. On the first one I've installed Debian/GNU 4.0 Linux, on the second FreeBSD 6.2. On both machines I've ...
    Jacek ZarębaJacek Zaręba
    Feb 21, 2007 at 10:17 am
    Feb 27, 2007 at 5:57 pm
  • Hi List, Machine was down due to some hardware problem. After then when i issue this command /usr/local/pgsql/bin/psql -l its giving me the following error psql: could not connect to server: No such ...
    Gauri KanekarGauri Kanekar
    Feb 26, 2007 at 1:22 pm
    Feb 26, 2007 at 2:05 pm
  • I would like to get someone's recommendations on the best initial settings for a dedicated PostgreSQL server. I do realize that there are a lot of factors that influence how one should configure a ...
    Campbell, LanceCampbell, Lance
    Feb 23, 2007 at 4:05 pm
    Feb 23, 2007 at 6:11 pm
  • Hi all, I'm using Postgresql 8.2.3 on a Windows XP system. I need to write and retrieve bytea data from a table. The problem is that, while data insertion is quite fast, bytea extraction is very ...
    MsmbarabinoMsmbarabino
    Feb 23, 2007 at 10:10 am
    Feb 26, 2007 at 9:03 am
  • Hi all, Following the work on Mark Stosberg on this list (thanks Mark!), I optimized our slow proximity queries by using cube, earthdistance (shipped with contrib) and a gist index. The result is ...
    Guillaume SmetGuillaume Smet
    Feb 13, 2007 at 5:09 pm
    Feb 16, 2007 at 6:31 pm
  • Hi folks, I don't know if this is an SQL or PERFORMANCE list problem but I wanted to check here first. I've seen this discussed on the list before but I'm still not sure of the solution. Maybe my ...
    Chuck D.Chuck D.
    Feb 13, 2007 at 7:04 pm
    Feb 14, 2007 at 7:12 pm
  • hi! I've been having some serious performance issues with postgresql8.2/hibernate/jdbc due to postgres reusing bad cached query plans. It doesn't look at the parameter values and therefore does not ...
    GeneGene
    Feb 26, 2007 at 4:13 pm
    Feb 26, 2007 at 5:41 pm
  • The postgresql.conf says that the maximum checkpoint_timeout is 1 hour. However, the following messages seem to suggest that it may be useful to set the value significantly higher to reduce ...
    Jeff DavisJeff Davis
    Feb 23, 2007 at 6:14 pm
    Feb 23, 2007 at 10:35 pm
  • Hello, I experience significant performance issues with postgresql and updates. I have a table which contains ~1M rows. Layout: TOTO=# \d versions_9d; Table «public.versions_9d» Colonne | Type | ...
    Gabriel BiberianGabriel Biberian
    Feb 22, 2007 at 6:19 pm
    Feb 23, 2007 at 6:18 am
  • Our application has a table that is only logged to, and infrequently used for reporting. There generally no deletes and updates. Recently, the shear size (an estimated 36 million rows) caused a ...
    Mark StosbergMark Stosberg
    Feb 21, 2007 at 6:03 pm
    Feb 21, 2007 at 10:04 pm
  • I have a new task of automating the export of a very complex Crystal Report. One thing I have learned in the last 36 hours is that the export process to PDF is really, really, slooww.. Anyway, that ...
    Dan HarrisDan Harris
    Feb 21, 2007 at 6:33 pm
    Feb 21, 2007 at 9:41 pm
  • Hello, I'm having a surprising performance problem with the following simple 'highscore report' select studentid, (select max(score) from studentprofile prof where prof.studentid = ...
    Marko NiinimakiMarko Niinimaki
    Feb 20, 2007 at 7:10 am
    Feb 21, 2007 at 5:34 am
  • There are 1.9M rows in ts_defects and indexes on b.ts_id (primary key) d.ts_biz_event_id and d.ts_occur_date. Both queries below return 0 rows. The 1st runs fast and the 2nd 400x slower. The 2nd ...
    Brian CoxBrian Cox
    Feb 12, 2007 at 9:51 pm
    Feb 13, 2007 at 3:36 am
  • All, I am looking to automate analyze table in my application. I have some insert only tables in my application which I need to analyze as data grows. Since the inserts are application controlled, I ...
    Virag SaksenaVirag Saksena
    Feb 10, 2007 at 12:05 am
    Feb 10, 2007 at 1:09 am
  • Hi all, Do someone already had some problem with performances using a pentium D (64 bits) and postgres 8.2.3 on a redhat enterprise update 2 ? I did the install from sources and nothing change... I ...
    HatmanHatman
    Feb 28, 2007 at 3:58 pm
    Mar 1, 2007 at 10:28 pm
  • Hi, I am in the process of cleaning up one of our big table, this table has 187 million records and we need to delete around 100 million of them. I am deleting around 4-5 million of them daily in ...
    Pallav KalvaPallav Kalva
    Feb 26, 2007 at 3:01 pm
    Feb 26, 2007 at 8:33 pm
  • Hello, I'm trying to make sense of the memory usage reported by 'top', compared to what "pg_database_size" shows. Here's one result: select pg_size_pretty(pg_database_size('production')); ...
    Mark StosbergMark Stosberg
    Feb 26, 2007 at 4:52 pm
    Feb 26, 2007 at 5:27 pm
  • Thanks for your reply, EXPLAIN ANALYSE show)? Here is the output of explain analyze SELECT * FROM "FILE" "Seq Scan on "FILE" (cost=0.00..1.36 rows=36 width=235) (actual time=0.023..0.107 rows=36 ...
    MsmbarabinoMsmbarabino
    Feb 23, 2007 at 12:20 pm
    Feb 23, 2007 at 4:35 pm
  • I am updating from 7.4.5 to 8.2.3. I have noticed a significant slowdown in simple searches such as "select filename from vnmr_data where seqfil = 'sems';" This returns 12 rows out of 1 million items ...
    Glenn SullivanGlenn Sullivan
    Feb 20, 2007 at 11:35 pm
    Feb 20, 2007 at 11:47 pm
  • PostgreSQL version: 8.1.6 OS: Debian etch The following query needs a lot of time because the query planner reorders the joins: select m.message_idnr, v.headervalue, n.headername from dbmail_messages ...
    Reinhard VicinusReinhard Vicinus
    Feb 19, 2007 at 5:26 pm
    Feb 20, 2007 at 4:45 pm
  • Hi I'm using posstgresql 8.1.4 on linux 2.6 shared_buffers = tested with 3000 and 10000 temp_buffers = 1000 work_mem = 4096 effective_cache_size = 65536 random_page_cost = 2 I have a query which I ...
    PhilippePhilippe
    Feb 15, 2007 at 2:43 pm
    Feb 15, 2007 at 5:11 pm
  • Hi, I am using PostgreSQL for benchmarking and I study the following query: SELECT * FROM k10_1, k10_2, k10_3, k10_4, k10_5 WHERE k10_1.times4 = k10_2.times4 AND k10_2.times4 = k10_3.times4 AND ...
    Konstantinos KrikellasKonstantinos Krikellas
    Feb 15, 2007 at 1:33 pm
    Feb 15, 2007 at 2:28 pm
  • Hi, I am having trouble understanding why a seqscan is chosen for this query. In practice the seqscan is very expensive, whereas the nested loop is usually quite fast, even with several hundred rows ...
    Brian HerlihyBrian Herlihy
    Feb 14, 2007 at 8:40 am
    Feb 15, 2007 at 1:30 am
  • Why should these queries have different plans? create table foo (a int PRIMARY KEY); Q1: explain select max(a) from foo I need the lovely index scan, but my table is hidden behind a view, and all I ...
    Bill HoweBill Howe
    Feb 2, 2007 at 1:44 am
    Feb 6, 2007 at 7:19 pm
  • I'm looking to replace some old crusty hardware with some sparkling new hardware. In the process, I'm looking to move away from the previous mentality of having the Big Server for Everything to ...
    BenBen
    Feb 2, 2007 at 12:41 am
    Feb 2, 2007 at 6:49 pm
  • Ok, looks like the FreeBSD community is interested in PostgreSQL performance, or at least enough to investigate it. Anyone here have experience hacking on FreeBSD? ----- Forwarded message from Kris ...
    Jim C. NasbyJim C. Nasby
    Feb 27, 2007 at 6:32 pm
    Feb 27, 2007 at 6:55 pm
  • Hi List, I have a Query. So when i do explain analyse on it , it shows me many Hash Joins. So is it possible to indicate the Query Planner not to consider Hash Join. -- Regards Gauri
    Gauri KanekarGauri Kanekar
    Feb 26, 2007 at 11:49 am
    Feb 26, 2007 at 11:52 am
  • Hi, Here is the situation. We are at postgres version 8.1.3. I have a table that gets many rows inserted, updated and then deleted, consistently throughout the day. At any point in time this table ...
    Barbara CosentinoBarbara Cosentino
    Feb 22, 2007 at 8:19 pm
    Feb 22, 2007 at 8:30 pm
  • Hi, I am trying to execute some queries in PostgreSQL that produce a large number of results and I do not want to display the output (redirect it to /dev/null). I have tried the psql client with \o ...
    Konstantinos KrikellasKonstantinos Krikellas
    Feb 22, 2007 at 11:02 am
    Feb 22, 2007 at 11:12 am
  • Postgres 8.1 Linux Redhat AS 4.X 4 processor box We have 12+ schemas in 1 database. When I do a unix "top" command I notice one postmaster process has 100% CPU usage. This process just stays at 100% ...
    Campbell, LanceCampbell, Lance
    Feb 13, 2007 at 6:34 pm
    Feb 13, 2007 at 6:49 pm
  • Hi, I have used postgresql some years now, but only small databases and only one database per instance and one user per database. Now we have a server reserved only for postgresql, and I'm wondering ...
    Ismo TuononenIsmo Tuononen
    Feb 13, 2007 at 9:12 am
    Feb 13, 2007 at 10:08 am
  • Hi, We have a quite big table, which is heavily used by our online clients. The table has several indexes, but no other relation to other tables. We have an import process, which can fill/update this ...
    Gábriel ÁkosGábriel Ákos
    Feb 9, 2007 at 6:24 pm
    Feb 9, 2007 at 7:10 pm
Group Navigation
period‹ prev | Feb 2007 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions59
posts354
users108
websitepostgresql.org
irc#postgresql

108 users for February 2007

Tom Lane: 34 posts Mark Stosberg: 26 posts Merlin Moncure: 17 posts Guillaume Smet: 16 posts Richard Huxton: 15 posts Steinar H. Gunderson: 11 posts Joshua D. Drake: 10 posts Kirk Wythers: 10 posts Benjamin Minshall: 8 posts Jeff Davis: 7 posts Alvaro Herrera: 6 posts Scott Marlowe: 6 posts Bruno Wolff III: 5 posts Carlos Moreno: 5 posts Gauri Kanekar: 5 posts Geoffrey: 5 posts Jim C. Nasby: 5 posts Michael Artz: 5 posts Dave Page: 4 posts Luke Lonergan: 4 posts
show more
Archives