Search Discussions

61 discussions - 504 posts

  • Hi all! I had an interesting discussion today w/ an Enterprise DB developer and sales person, and was told, twice, that the 64-bit linux version of Enterprise DB (which is based on the 64-bit version ...
    Anthony PresleyAnthony Presley
    Jun 12, 2006 at 11:00 pm
    Jun 14, 2006 at 9:25 pm
  • Hello, I've noticed some posts on hanging queries but haven't seen any solutions yet so far. Our problem is that about a week and a half ago we started to get some queries that would (seemingly) ...
    Chris BeecroftChris Beecroft
    Jun 5, 2006 at 7:17 pm
    Jun 21, 2006 at 7:49 am
  • Hello, I am setting up a postgres server that will hold a critical event witin the next few weeks. It's national exam result (140000 students) the problem is that the first few hours there will be a ...
    Jun 3, 2006 at 9:36 am
    Jun 21, 2006 at 7:33 am
  • We have a customer who are having performance problems. They have a large (36G+) postgres 8.1.3 database installed on an 8-way opteron with 8G RAM, attached to an EMC SAN via fibre-channel (I don't ...
    Tim AllenTim Allen
    Jun 15, 2006 at 9:50 pm
    Jun 23, 2006 at 12:02 pm
  • Hey - I am running into a data relation bloat problem which I believe is causing fairly significant slowdown of my updates. I am using version version ...
    Jody brownellJody brownell
    Jun 21, 2006 at 1:53 pm
    Jun 23, 2006 at 12:40 pm
  • Just so I don't think I'm insane: warehouse=# explain analyze select e.event_date::date warehouse-# from l_event_log e warehouse-# JOIN c_event_type t ON (t.id = e.event_type_id) warehouse-# WHERE ...
    Shaun ThomasShaun Thomas
    Jun 13, 2006 at 5:53 pm
    Jun 15, 2006 at 3:50 pm
  • I'm not a programmer so understanding the optimizer code is WAY beyond my limits. My question, that I haven't seen answered elsewhere, is WHAT things can affect the choice of an index scan over a ...
    John VincentJohn Vincent
    Jun 15, 2006 at 6:05 pm
    Jun 24, 2006 at 4:28 am
  • I am thrill to inform you all that Sun has just donated a fully loaded T2000 system to the PostgreSQL community, and it's being setup by Corey Shields at OSL (osuosl.org) and should be online ...
    Robert LorRobert Lor
    Jun 16, 2006 at 3:22 pm
    Jun 22, 2006 at 3:04 pm
  • I have a client who is running Postgresql 7.4.x series database (required to use 7.4.x). They are planning an upgrade to a new server. They are insistent on Dell. I have personal experience with AMD ...
    Steve PoeSteve Poe
    Jun 13, 2006 at 6:02 pm
    Jun 15, 2006 at 5:47 pm
  • Hi, Im having a problem with postgres 8.1.3 on a Fedora Core 3 (kernel 2.6.9-1.667smp) I have two similar servers, one in production and another for testing purposes. Databases are equal (with a ...
    Ruben Rubio ReyRuben Rubio Rey
    Jun 12, 2006 at 2:39 pm
    Jun 13, 2006 at 11:48 am
  • -- this is the third time I've tried sending this and I never saw it get through to the list. Sorry if multiple copies show up. Hi all, I've been lurking using the web archives for a while and ...
    John E. VincentJohn E. Vincent
    Jun 14, 2006 at 3:14 pm
    Jun 16, 2006 at 1:04 am
  • Hi, I would like to know if my supposition is right. Considering an environment with only one hard disk attached to a server, an initial loading of the database probably is much faster using an ...
    Jun 2, 2006 at 6:25 pm
    Jun 4, 2006 at 2:23 am
  • Hello People, I'm trying to solve a 'what i feel is a' performance/configuration/query error on my side. I'm fairly new to configuring PostgreSQL so, i might be completely wrong with my ...
    Jun 21, 2006 at 2:19 pm
    Jun 22, 2006 at 12:20 pm
  • I have a box with an app and postgresql on it. Hardware includes with 2 2.8 Ghz xeons 512KB cache, 4 GB of memory, 6 scsi disk in a software raid 5 on a trustix 2.2 with a kernel. The data ...
    Jody brownellJody brownell
    Jun 14, 2006 at 7:30 pm
    Jun 15, 2006 at 5:18 pm
  • All, So I thought I'd pose this question: If I have a pg database attached to a powervault (PV) with just an off-the-shelf SCSI card I generally want fsync on to prevent data corruption in case the ...
    Dan GormanDan Gorman
    Jun 14, 2006 at 9:48 pm
    Jun 15, 2006 at 3:54 pm
  • Why Postgres 8.1 does not use makse_kuupaev_idx index in the following query ? How to speed this query up ? explain analyze select * from makse order by kuupaev desc, kellaaeg desc limit 100 "Limit ...
    Jun 8, 2006 at 6:55 pm
    Jun 9, 2006 at 3:54 pm
  • Hello, We have to take a backup of database and we know the pg_dump utility of postgresql. But may I know, is there any API for this pg_dump utility so that we can call it from the C program? Or only ...
    Soni deSoni de
    Jun 8, 2006 at 6:10 am
    Jun 9, 2006 at 2:22 pm
  • hi i'm waiting for new server to arrive. for the server i will get hp msa1000, with 14 discs (72g, 15000 rpm). what kind of partitioning you suggest, to get maximum performance? for system things i ...
    Hubert depesz lubaczewskiHubert depesz lubaczewski
    Jun 14, 2006 at 7:52 am
    Sep 4, 2006 at 6:06 pm
  • My application has a function, call it "foo()", that requires initialization from a table of about 800 values. Rather than build these values into the C code, it seemed like a good idea to put them ...
    Craig A. JamesCraig A. James
    Jun 11, 2006 at 5:19 pm
    Jun 30, 2006 at 6:05 am
  • Hi, Is it possible to start two instances of postgresql with different port and directory which run simultaneously? If can then will this cause any problem or performance drop down? Thanks.
    Jun 15, 2006 at 5:58 am
    Jun 15, 2006 at 5:53 pm
  • Hi, We just don't seem to be getting much benefit from autovacuum. Running a manual vacuum seems to still be doing a LOT, which suggests to me that I should either run a cron job and disable ...
    Jun 1, 2006 at 11:54 am
    Jun 7, 2006 at 10:17 pm
  • Howdy, Didn't see anything in the archives, so I thought I'd ask: has anyone done any work to gauge the performance penalty of using DOMAINs? I'm thinking of something like Elein's email DOMAIN: ...
    David WheelerDavid Wheeler
    Jun 21, 2006 at 6:26 pm
    Jun 22, 2006 at 6:18 pm
  • Hi, here's my problem: # explain analyze select * from mxstrpartsbg where szam = round(800000*random())::integer; QUERY PLAN ...
    Böszörményi ZoltánBöszörményi Zoltán
    Jun 14, 2006 at 10:54 am
    Jun 17, 2006 at 7:45 pm
  • Hi, I don't have a copy of the standard on hand and a collegue is claiming that there must be a from clause in a select query (he is an oracle guy). This doesn't seem to be the case for postgres... ...
    Jun 13, 2006 at 12:43 pm
    Jun 14, 2006 at 7:04 pm
  • For long involved reasons I'm hanging out late at work today, and rather than doing real, productive work, I thought I'd run some benchmarks against our development PostgreSQL database server. My ...
    Brian HurtBrian Hurt
    Jun 20, 2006 at 12:09 am
    Jun 28, 2006 at 3:41 pm
  • We just purchased a new Dell PowerEdge 2800 (dual xeon, 8GB RAM, raid 4, RHEL, postgres 8.1) and ported our old database over to it (single cpu, 2GB RAM, no raid, postgres 7.4). Our apps perform ...
    Ron St-PierreRon St-Pierre
    Jun 21, 2006 at 3:42 pm
    Jun 22, 2006 at 9:15 pm
  • unsubscribe
    Diego GaviolaDiego Gaviola
    Jun 26, 2006 at 10:45 pm
    Jul 11, 2006 at 8:43 pm
  • Hello! I am trying to delete an entire table. There are about 41,000 rows in the table (based on count(*)). I am using the SQL comment: delete from table; The operation seems to take in the order of ...
    David LeangenDavid Leangen
    Jun 16, 2006 at 7:06 am
    Jun 16, 2006 at 1:30 pm
  • I have a index question. My table has 800K rows and I a doing a basic query on an indexed integer field which takes over 2 seconds to complete because it's ignoring the index for some reason. Any ...
    Joe LesterJoe Lester
    Jun 30, 2006 at 2:05 pm
    Jun 30, 2006 at 6:21 pm
  • Hello all I have a big amount of phone calls data (280M records, 25 Gbytes).The best decision for this task is partitioning and I use it now. But at first I tried put all data in a single table ...
    Andrew SagulinAndrew Sagulin
    Jun 27, 2006 at 12:23 pm
    Jun 28, 2006 at 3:08 pm
  • Hello, I see in the documentation that we can obtain the number of pages for a table with the view named pg_class. I would want if it is possible for each pages of a table to have the occupation of ...
    Jun 23, 2006 at 10:29 am
    Jun 26, 2006 at 12:34 pm
  • Hi, I have some speed issues with a big array in a table. I hope you can help me to tune my query. My table looks like this: Id | timestamp | map Primary key | timestamp | array of real [34][28] With ...
    Merkel Marcel (CR/AEM4)Merkel Marcel (CR/AEM4)
    Jun 20, 2006 at 9:59 am
    Jun 21, 2006 at 7:49 pm
  • How to speed the following query? It seems to run forever. explain SELECT bilkaib.DB, CASE WHEN dbkonto.objekt1='+' THEN bilkaib.DBOBJEKT ELSE '' END AS dbobjekt, CASE WHEN dbkonto.objekt2='+' THEN ...
    Jun 22, 2006 at 6:23 pm
    Jun 27, 2006 at 6:02 pm
  • Hello, I´m have some problems with a temporary table, i need create a table, insert some values, make a select and at end of transaction the table must droped, but after i created a table there not ...
    Franklin HautFranklin Haut
    Jun 23, 2006 at 9:52 pm
    Jun 24, 2006 at 12:22 am
  • Hello, During insert or update, potgresql write in pgsql_tmp directory and so performance are very poor. My configuration is: Work mem 10240 Effective_cache_size 30000 Shared buffers 9000 ...
    Domenico - Sal. F.lli RivaDomenico - Sal. F.lli Riva
    Jun 9, 2006 at 12:29 pm
    Jun 12, 2006 at 3:15 pm
  • I have this table setup on a 8.1.4 server: pj_info_attach(attachment_nr, some more cols) -- index, 50k rows pj_info_attach_compressable() INHERITS (pj_info_attach) -- index, 1M rows ...
    Andreas PflugAndreas Pflug
    Jun 8, 2006 at 11:41 am
    Jun 8, 2006 at 4:42 pm
  • Hello, We have database on which continueous operations of INSERT, DELETE, UPDATE are going on, In the mean time irrespective of INSERT and UPDATE we want to ALTER some filelds from the table can we ...
    Soni deSoni de
    Jun 7, 2006 at 12:43 pm
    Jun 8, 2006 at 3:04 pm
  • I have UTF-8 Postgres 8.1 database on W2K3 Query SELECT toode, nimetus FROM toode WHERE toode ILIKE 'x10%' ESCAPE '!' ORDER BY UPPER(toode ),nimetus LIMIT 100 runs 1 minute in first time for small ...
    Jun 5, 2006 at 7:29 pm
    Jun 6, 2006 at 2:24 pm
  • Hi Tom, I don't know anything about how PG stores keys along with their references to the actual rows but my assumption was that that reference is some sort of an index into a table that maps the ...
    Jozsef SzalayJozsef Szalay
    Jun 30, 2006 at 3:26 pm
    Jul 2, 2006 at 2:36 pm
  • Here is a subtle question about SQL. I have a one-to-many pair of tables (call them "P" and "C" for parent and child). For each row of P, there are many rows in C with data, and I want to sort P on ...
    Craig A. JamesCraig A. James
    Jun 25, 2006 at 6:36 pm
    Jun 30, 2006 at 6:21 am
  • I have a producer/consumer setup where various producer processes insert new records into a table and consumer processes mark those records as having been handled when they have dealt with them, but ...
    Richard Frith-MacdonaldRichard Frith-Macdonald
    Jun 16, 2006 at 7:39 am
    Jun 23, 2006 at 12:44 am
  • I would expect that clustering on the name would be better for the above query. You probably want an index on name and date combined.
    Bruno Wolff IIIBruno Wolff III
    Jun 16, 2006 at 3:28 pm
    Jun 16, 2006 at 7:00 pm
  • Hello, Is it possible to somehow analyze function performance? E.g. we are using function cleanup() which takes obviously too much time to execute but I have problems trying to figure what is slowing ...
    Jun 15, 2006 at 12:43 pm
    Jun 15, 2006 at 2:24 pm
  • AFAIK, the reason why seperating pg_xlog from the base files provides so much performance is because the latency on pg_xlog is critical: a transaction can't commit until all of it's log data is ...
    Jim C. NasbyJim C. Nasby
    Jun 9, 2006 at 7:41 pm
    Jun 10, 2006 at 2:29 am
  • The situation is this: we're using a varchar column to store alphanumeric codes which are by themselves 7-bit clean. But we are operating under a locale which has its own special collation rules, and ...
    Ivan VorasIvan Voras
    Jun 7, 2006 at 7:58 pm
    Jun 7, 2006 at 11:06 pm
  • when i try do \d in psql on a table i get this message! this happens too when i try to run pg_dump... ERROR: could not access status of transaction 4294967295 DETAIL: could not open file ...
    Jun 1, 2006 at 5:37 pm
    Jun 5, 2006 at 2:48 pm
  • I have SP, which has a cursor iterations. Need to call another SP for every loop iteration of the cursor. The pseudo code is as follows.. Create proc1 as Begin Variable declrations... declare ...
    Jun 29, 2006 at 5:00 pm
    Jul 7, 2006 at 1:21 pm
  • Hi, Alfter hours of adjusting performance of the queries in my Postgres 7.3 database - reprogramming the queries, VACUUMing, changing value of enable_seqscan - I gived it up, recreated the database ...
    Ksenia MarasanovaKsenia Marasanova
    Jun 30, 2006 at 2:14 pm
    Jun 30, 2006 at 2:36 pm
  • Folks, Jozsef is having trouble posting to the list, but he's receiving messages fine. So reply to the list and not to me. Message follows: -------- Original Message ------- The original post: Title: ...
    Josh BerkusJosh Berkus
    Jun 30, 2006 at 6:33 am
    Jun 30, 2006 at 6:44 am
  • -- Best, Gourish Singbal
    Gourish SingbalGourish Singbal
    Jun 27, 2006 at 2:04 pm
    Jun 27, 2006 at 5:16 pm
Group Navigation
period‹ prev | Jun 2006 | next ›
Group Overview
grouppgsql-performance @

123 users for June 2006

Jim Nasby: 61 posts Tom Lane: 61 posts John Vincent: 17 posts Scott Marlowe: 15 posts Jody brownell: 14 posts Sven Geisler: 13 posts Andrus: 9 posts Josh Berkus: 9 posts Markus Schaber: 9 posts Greg Stark: 8 posts Mark Lewis: 8 posts Mischa Sandberg: 8 posts Ruben Rubio Rey: 8 posts Craig A. James: 7 posts Luke Lonergan: 6 posts PFC: 6 posts Simon Riggs: 6 posts Steinar H. Gunderson: 6 posts Zoltan Boszormenyi: 6 posts Andrew Sullivan: 5 posts
show more