FAQ

PostgreSQL > pgsql-performance > July 2008

Search Discussions

46 discussions - 281 posts

  • Morning folks, Long time listener, first time poster. Having an interesting problem related to performance which I'll try and describe below and hopefully get some enlightenment. First the ...
    Dave NorthDave North
    Jul 30, 2008 at 12:14 pm
    Aug 7, 2008 at 3:08 pm
  • I have a PostgreSQL database on a very low-resource Xen virtual machine, 48 MB RAM. When two queries run at the same time, it takes longer to complete then if run in sequence. Is there perhaps a way ...
    MiernikMiernik
    Jul 23, 2008 at 4:22 pm
    Jul 31, 2008 at 3:31 pm
  • I recently got my hands on a device called ioDrive from a company called Fusion-io. The ioDrive is essentially 80GB of flash on a PCI card. It has its own driver for Linux completely outside of the ...
    Jeffrey BakerJeffrey Baker
    Jul 2, 2008 at 12:42 am
    Jul 8, 2008 at 7:24 pm
  • I've got a couple boxes with some 3ware 9550 controllers, and I'm less than pleased with performance on them.. Sequential access is nice, but start seeking around and you kick it in the gut. (I've ...
    JeffJeff
    Jul 11, 2008 at 1:32 pm
    Jul 20, 2008 at 11:10 pm
  • I have two postgresql servers. One runs 8.3.1, the other 8.3.3. On the 8.3.1 machine, the index scans are being planned extremely low cost: explain ANALYZE select * from email_entity where ...
    Jeff FrostJeff Frost
    Jul 17, 2008 at 9:21 pm
    Aug 9, 2008 at 6:21 am
  • I'm trying to run a few basic tests to see what a current machine can deliver (typical workload ETL like, long running aggregate queries, medium size db ~100 to 200GB). I'm currently checking the ...
    Stephane BailliezStephane Bailliez
    Jul 19, 2008 at 1:20 pm
    Jul 22, 2008 at 8:36 pm
  • Dear PostgreSQL community, first some info about our application: - Online course directory for a University - Amount of data: complete dump is 27 MB - Semester is part of primary key in each table - ...
    Andreas HartmannAndreas Hartmann
    Jul 21, 2008 at 10:50 am
    Jul 22, 2008 at 8:22 am
  • Hi i have experienced really bad performance on both FreeBSD and linux, with syslog, when logging statements involving bytea of size ~ 10 Mb. Consider this scenario: [email protected]=# \d ...
    Achilleas MantziosAchilleas Mantzios
    Jul 8, 2008 at 12:27 pm
    Jul 9, 2008 at 12:58 pm
  • Hi all, We have upgraded our database server to postgres 8.3.1 on 28th June. Checked out the performance of Hot on 30th June : relname n_tup_ins n_tup_upd n_tup_del n_tup_hot_upd n_live_tup ...
    Gauri KanekarGauri Kanekar
    Jul 2, 2008 at 12:31 pm
    Jul 2, 2008 at 4:35 pm
  • Hi, I have ran quite a few tests comparing how long a query takes to execute from Perl/DBI as compared to psql/pqlib. No matter how many times I run the test the results were always the same. I run a ...
    Valentin BogdanovValentin Bogdanov
    Jul 21, 2008 at 11:19 am
    Jul 23, 2008 at 10:47 am
  • Is there any quick hacks to do this quickly? There's around 20-30million rows of data. I want to change a column type from varchar(4) to varchar() table size is ~10-15GB (and another 10-15G for ...
    Ow Mun HengOw Mun Heng
    Jul 10, 2008 at 7:53 am
    Jul 14, 2008 at 1:46 am
  • Hi there, I have a script which includes 30000 called functions within a single transaction. At the beginning, the functions runs fast enough (about 60 ms each). In time, it begins to run slower and ...
    Sabin CoandaSabin Coanda
    Jul 18, 2008 at 3:41 pm
    Aug 18, 2008 at 12:05 am
  • Hi All, I have taken over the maintenance of a server farm , recently. 2 webserver on db server. They are quite powerful 2 processor xeon w/ 6Gig of ram . Couple of days ago we had a serious ...
    Faludi GáborFaludi Gábor
    Jul 28, 2008 at 6:50 am
    Jul 30, 2008 at 6:59 pm
  • Dear all, After setting log_statement='all' at postgres.conf, then i'm rebooting OS [freeBSD or CentOS], i can't find where log file created from log_statement='all' located... FYI, location of ...
    System/IJS - JokoSystem/IJS - Joko
    Jul 17, 2008 at 9:15 am
    Jul 21, 2008 at 8:27 am
  • Hi Guys, I am developing a project with PostgreSQL and one guy from project is familiar with Oracle and did a question for me, but i could not answer, if someone could help it will be good. =) The ...
    Leví Teodoro da SilvaLeví Teodoro da Silva
    Jul 21, 2008 at 6:23 pm
    Jul 21, 2008 at 7:03 pm
  • Hi guys, How are you ? I am from Brazil and i work for a little company and it company is working is medium-big project and we want to use PostGree like the DataBase system, but i got some questions. ...
    Leví Teodoro da SilvaLeví Teodoro da Silva
    Jul 2, 2008 at 6:31 pm
    Jul 14, 2008 at 2:23 pm
  • Hi All, I am having a trigger in table, If I update the the table manually trigger is firing immediately(say 200ms per row), But if I update the table through procedure the trigger is taking time to ...
    PraveenPraveen
    Jul 14, 2008 at 6:37 am
    Jul 14, 2008 at 9:48 am
  • I have a table with 29K rows total and I need to delete about 80K out of it. I have a b-tree index on column cola (varchar(255) ) for my where clause to use. my "select count(*) from test where cola ...
    Jessica RichardJessica Richard
    Jul 4, 2008 at 12:51 am
    Jul 4, 2008 at 3:48 pm
  • For background, please read the thread "Fusion-io ioDrive", archived at http://archives.postgresql.org/pgsql-performance/2008-07/msg00010.php To recap, I tested an ioDrive versus a 6-disk RAID with ...
    Jeffrey W. BakerJeffrey W. Baker
    Jul 23, 2008 at 12:12 am
    Sep 3, 2008 at 4:39 am
  • Hi All, This is my first post so please be gentle if I make any mistakes. I know that ENUMs were not intended to be used instead of joins, but I believe that I my case there will be huge saves on ...
    David AndersenDavid Andersen
    Jul 26, 2008 at 9:22 pm
    Jul 27, 2008 at 12:53 am
  • On a Linux system, if the total memory is 4G and the shmmax is set to 4G, I know it is bad, but how bad can it be? Just trying to understand the impact the "shmmax" parameter can have on Postgres and ...
    Jessica RichardJessica Richard
    Jul 10, 2008 at 10:54 am
    Jul 10, 2008 at 3:37 pm
  • Two queries which do the same thing, first one takes ages to complete (did wait several minutes and cancelled it), while the second one took 9 seconds? Don't they do the same thing? miernik= EXPLAIN ...
    MiernikMiernik
    Jul 31, 2008 at 2:45 am
    Jul 31, 2008 at 3:55 am
  • I am facing performance issues with running scheduled jobs. There are multiple jobs running on the database ...not necessarily acting on the same table. Either ways i checked if there was a locking ...
    Samantha mahindrakarSamantha mahindrakar
    Jul 22, 2008 at 4:00 pm
    Jul 23, 2008 at 1:15 am
  • Hi I have a select statement that runs on a partition having say couple million rows. The tabel has indexes on two colums. However the query uses the non-indexed colums too in its where clause. For ...
    Samantha mahindrakarSamantha mahindrakar
    Jul 1, 2008 at 7:29 pm
    Jul 2, 2008 at 7:07 pm
  • Interesting read... http://www.linux.com/feature/142658
    Matthew T. O'ConnorMatthew T. O'Connor
    Jul 31, 2008 at 5:45 pm
    Aug 4, 2008 at 11:25 am
  • Hello friends The commands "\timing" and "EXPLAIN ANALYZE" return values related to the time of execution of the instruction. These values are "Time:" and "Total runtime:" respectively. What is the ...
    TarcizioabTarcizioab
    Jul 31, 2008 at 12:53 am
    Jul 31, 2008 at 1:08 am
  • Hi guys, I've got a query that is running slower on 8.3 than on 8.1 (with equivalent server config), because the join ordering is not the same, at least that's my guess... ;-) In 8.1.4, table A had ...
    Patrick VachonPatrick Vachon
    Jul 16, 2008 at 9:38 pm
    Jul 22, 2008 at 4:34 pm
  • Hi, When trying to to set shared_buffers greater then 3,5 GB on 32 GB x86 machine with solaris 10 I running in this error: FATAL: requested shared memory size overflows size_t The solaris x86 ist ...
    Uwe BartelsUwe Bartels
    Jul 15, 2008 at 10:26 am
    Jul 15, 2008 at 9:53 pm
  • Hi All, I am having a trigger in table, If i update the the table manually it is not taking time(say 200ms per row), But if i update the table through procedure the trigger is taking time to fire(say ...
    RamasubramanianRamasubramanian
    Jul 11, 2008 at 7:36 am
    Jul 14, 2008 at 6:08 pm
  • On a running production machine, we have 900M configured on a 16G-memory Linux host. The db size for all dbs combined is about 50G. There are many transactions going on all the times (deletes, ...
    Jessica RichardJessica Richard
    Jul 12, 2008 at 11:30 am
    Jul 12, 2008 at 2:30 pm
  • Hi, I just noticed what looks like a deadlock situation on postgresql 8.2.4. After more than an hour of running REINDEX, two processes are each in a "waiting" state and yet have no time used. This is ...
    Karl WrightKarl Wright
    Jul 11, 2008 at 5:23 pm
    Jul 11, 2008 at 9:39 pm
  • Hi, when i issued the vaccuum cmd, I recieved this message: echo "VACUUM --full -d ARSys" | psql -d dbname WARNING: relation "public.tradetbl" contains more than "max_fsm_pages" pages with useful ...
    Radhika SRadhika S
    Jul 8, 2008 at 7:14 pm
    Jul 9, 2008 at 3:59 pm
  • I'm spending a third day testing with the ioDrive, and it occurred to me that I should normalize my tests by mounting the database on a ramdisk. The results were surprisingly low. On the single ...
    Jeffrey BakerJeffrey Baker
    Jul 7, 2008 at 9:06 pm
    Jul 8, 2008 at 3:57 am
  • How can I tell if my work_mem configuration is enough to support all Postgres user activities on the server I am managing? Where do I find the indication if the number is lower than needed. Thanks, ...
    Jessica RichardJessica Richard
    Jul 5, 2008 at 11:24 am
    Jul 7, 2008 at 11:16 am
  • Hi. I have a table with 1.8M rows on a Postgres 8.1.4 server, and I'm executing a query which looks like: select count(*) from header_fields where message in (select message from mailbox_messages ...
    Abhijit Menon-SenAbhijit Menon-Sen
    Jul 3, 2008 at 7:59 am
    Jul 3, 2008 at 11:45 am
  • Hi, i have a table with a huge amount of rows (actually 4 millions and a half), defined like this: CREATE TABLE rtp_frame ( i_len integer NOT NULL, i_file_offset bigint NOT NULL, i_file_id integer ...
    Emiliano LeporatiEmiliano Leporati
    Jul 1, 2008 at 11:15 am
    Jul 1, 2008 at 2:18 pm
  • hi list, i have a problem with time consuming query. first of all my table structure: CREATE TABLE nw_tla_2008_4_deu ( "ID" bigint NOT NULL, "NET2CLASS" smallint, "FOW" smallint, CONSTRAINT ...
    Stefan ZweigStefan Zweig
    Jul 18, 2008 at 10:29 am
    Aug 13, 2008 at 3:45 pm
  • AFAIK, provided bar is UNIQUE in table2 (e.g. is a PRIMARY KEY) the two queries will give the same result: SELECT foo, id FROM table1 WHERE id IN (SELECT id FROM table2); SELECT foo, id FROM table1 ...
    MiernikMiernik
    Jul 30, 2008 at 10:12 pm
    Jul 31, 2008 at 6:47 am
  • Hi all, Have a problem related to partition tables. We have the following schema's : master - id integer (PRIMARY KEY) cid integer child1, child2 are the child tables of master table. Here "cid" is ...
    Gauri KanekarGauri Kanekar
    Jul 24, 2008 at 10:15 am
    Jul 25, 2008 at 10:32 pm
  • PostgreSQL: 8.2 How can I identify how many inserts and updates are being done in a given time frame for a database? Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public ...
    Campbell, LanceCampbell, Lance
    Jul 11, 2008 at 9:39 pm
    Jul 11, 2008 at 9:47 pm
  • Hi, Here http://www.westnet.com/~gsmith/content/postgresql/TuningPGWAL.htm I read: """ Combining these two, an optimal fstab for the WAL might look like this: /dev/hda2 /var ext3 ...
    Jaime CasanovaJaime Casanova
    Jul 6, 2008 at 5:04 am
    Jul 6, 2008 at 3:18 pm
  • Hi, We are seeing system hang-up issue when we do continuous update on table ( 2-3 records/sec) within 10-12 hours. Memory parameter Inact_dirty( shown in /proc/meminfo) is increasing continuously ...
    Kathirvel, JeevanandamKathirvel, Jeevanandam
    Jul 1, 2008 at 12:26 pm
    Jul 1, 2008 at 3:07 pm
  • Dear friend, * **We are an electronic products wholesaler located in Shenzhen China .Our products are of high quality and competitive price. If you want to find the best supplier , we can offer you ...
    Krishna KumarKrishna Kumar
    Jul 18, 2008 at 9:31 am
    Jul 18, 2008 at 9:31 am
  • On a new system with 64G memory, what is the best starting points for shmmax on OS and shared_buffers for Postgres. All databases combined are about 50G. I want to evaluate this with the two ...
    Jessica RichardJessica Richard
    Jul 12, 2008 at 12:03 pm
    Jul 12, 2008 at 12:03 pm
  • PostgreSQL: 8.2 How can you identify how many inserts are being done in a given time frame for a database? Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs ...
    Campbell, LanceCampbell, Lance
    Jul 11, 2008 at 9:39 pm
    Jul 11, 2008 at 9:39 pm
  • Hi, I have juste some questions about cursor/Fetch mechanisms under postgreSQL. Do it use only scan table approach when one fetch (next) is executed or it takes into account index when this lasts one ...
    Mokhtari AmineMokhtari Amine
    Jul 3, 2008 at 10:19 am
    Jul 3, 2008 at 10:19 am
Jul 2008
Group Navigation
period‹ prev | Jul 2008 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions46
posts281
users100
websitepostgresql.org
irc#postgresql

100 users for July 2008

Tom Lane: 21 posts Scott Marlowe: 16 posts Greg Smith: 14 posts Jeffrey W. Baker: 12 posts Miernik: 10 posts Richard Huxton: 9 posts Craig Ringer: 7 posts Gauri Kanekar: 6 posts Jessica Richard: 6 posts Achill: 5 posts Alvaro Herrera: 5 posts Dave North: 5 posts Jonah H. Harris: 5 posts Andreas Hartmann: 4 posts Bill Moran: 4 posts Craig James: 4 posts Jeff: 4 posts Leví Teodoro da Silva: 4 posts Mark Roberts: 4 posts Ow Mun Heng: 4 posts
show more
Archives