Search Discussions

25 discussions - 258 posts

  • There had been a great deal of discussion of how to improve the performance of select/sorting on this list, what about insert/delete/update? Is there any rules of thumb we need to follow? What are ...
    Wei WengWei Weng
    Nov 21, 2002 at 8:14 pm
    Nov 26, 2002 at 7:40 pm
  • Hi, Why is the sort part of my query getting so much time? I run a relative complex query and it gets about 50 sec. For sorting I need another 50 sec! Can I increase the sort memory for better ...
    Nov 14, 2002 at 5:39 pm
    Nov 18, 2002 at 11:56 am
  • Henrik, First off, I'm moving this discussion to the PGSQL-PERFORMANCE list, where it belongs. To subscribe, send the message "subscribe pgsql-perform your@email.address" to ...
    Josh BerkusJosh Berkus
    Nov 13, 2002 at 5:02 pm
    Nov 15, 2002 at 6:53 pm
  • Good to know. What do you think is faster: 3 drives in raid 1 or 3 drives in raid 5? Regards, Bjoern
    Björn MetzdorfBjörn Metzdorf
    Nov 21, 2002 at 8:53 pm
    Nov 22, 2002 at 3:01 pm
  • pgsql-performers, Just out of curiosity, anybody with any ideas on what happens to this query when the limit is 59626? It's as though 59626 = infinity? pganalysis= explain analyze select * from ps2 ...
    Mike NielsenMike Nielsen
    Nov 11, 2002 at 5:44 pm
    Dec 3, 2002 at 3:23 pm
  • Hi All, We are using Postgres 7.1, on Solaris 8 - hardware is a 400mhz Netra X1, 512Mb ram, with the database on a separate partition. Our main result tables are getting really big, and we don't want ...
    Nikk AndersonNikk Anderson
    Nov 18, 2002 at 12:33 pm
    Nov 20, 2002 at 8:26 pm
  • So, I'm trying to create a full text index as described here: http://techdocs.postgresql.org/techdocs/fulltextindexing.php Everything was going mostly okay... I had to hack a quick PHP script instead ...
    Nov 26, 2002 at 9:36 am
    Dec 16, 2002 at 6:35 pm
  • In our first installment a couple of weeks ago, I was asking about low end hardware optimizations, it got into ide/scsi, memory, and drive layout issues. I've been wondering more about the IDE/SCSI ...
    Eric soroosEric soroos
    Nov 27, 2002 at 6:51 pm
    Dec 4, 2002 at 8:36 pm
  • hello all, how often should "vacuum full" usually be run ? thanks, -- Mit freundlichem Gruß Henrik Steffen Geschäftsführer top concepts Internetmarketing GmbH Am Steinkamp 7 - D-21684 Stade - Germany ...
    Henrik SteffenHenrik Steffen
    Nov 21, 2002 at 4:52 pm
    Nov 21, 2002 at 9:26 pm
  • Does it make a performance difference if I use a char(20) or a char(36) as the primary key? My thought is no, but I would like to hear more opinions. And a little further off topic(since we have many ...
    Wei WengWei Weng
    Nov 1, 2002 at 8:18 pm
    Nov 4, 2002 at 4:08 am
  • Hi , For a particular table it was only dump and reload of the table that helped in enabling index usage. I tried VACUUM ANALYZE and even recreating the indexes but it did not work. why does the ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Nov 1, 2002 at 11:15 am
    Nov 1, 2002 at 7:54 pm
  • The term had been mentioned often enough on this mailing list. Can someone enlighten me with some description or a URL where I can read on? And why is it important to postgresql database performace? ...
    Wei WengWei Weng
    Nov 14, 2002 at 2:30 pm
    Nov 15, 2002 at 9:42 am
  • Hi! I've seen on this list some calculations concerning buffers and sort_mem settings. Could you tell me if there is a document about such a calculation? I'd like to use nearly all of my RAM for ...
    Ryszard LachRyszard Lach
    Nov 14, 2002 at 9:44 am
    Nov 14, 2002 at 7:27 pm
  • Hi all, i've a doubt about how FOR/LOOP works in plpgsql. It seems to me that the SELECT query executed in that way is much slower that the same being executed interactively in psql. In particular it ...
    Nov 15, 2002 at 12:38 pm
    Nov 19, 2002 at 2:08 pm
  • Hi, I have table with 30 columns and 30000..500000 rows. When I make 'SELECT * FROM table' postgresql start doing something and return first row after 10s (for 30k rows) and after 5min (500k rows). ...
    Jirka NovakJirka Novak
    Nov 11, 2002 at 10:08 am
    Nov 12, 2002 at 7:30 am
  • Direct Cc: would be MUCH appreciated! I'm using PostgreSQL 7.1.3 My FIRST question is: How come I can't seem to get any of that nifty profiling output to /var/log/messages? [aside] Not in ...
    Nov 20, 2002 at 11:40 pm
    Nov 21, 2002 at 7:41 pm
  • Good ideas. I think the master solution is to hook the statistics daemon information into an automatic vacuum that could _know_ which tables need attention. ...
    Bruce MomjianBruce Momjian
    Nov 26, 2002 at 7:16 pm
    Nov 27, 2002 at 3:23 pm
  • Hello, does have IN operator in WHERE clausule any "undocumented" slowdown? I have tables: CREATE TABLE A ( pkA int NOT NULL num int ... ); CREATE TABLE B ( fkA int NOT NULL, ... ); ALTER TABLE B ADD ...
    Jirka NovakJirka Novak
    Nov 19, 2002 at 2:26 pm
    Nov 19, 2002 at 2:45 pm
  • Is it possible to configure the digest form for this list? It's starting to get busy (which is relative I know, but I'm on a lot of lists and prefer digest...others too?). Thanks, -- Laurette ...
    Laurette CisnerosLaurette Cisneros
    Nov 14, 2002 at 9:46 pm
    Nov 15, 2002 at 12:34 am
  • Just for the humor of it, as well as to confirm Nick's perspective, years ago on our inhouse developed Burroughs mainframe dbms, we had a process called "garbage collect". Nicolai Tufar wrote:
    Jim BeckstromJim Beckstrom
    Nov 27, 2002 at 3:07 pm
    Nov 27, 2002 at 5:20 pm
  • subscribe
    Francisco ReyesFrancisco Reyes
    Nov 20, 2002 at 6:53 pm
    Nov 21, 2002 at 8:42 pm
  • Hi! This is my first post to the list. I'm currently searching to improve the performances of some requests, and recently switched to postgresql 7.3rc1. I thought there would be in this release a ...
    David PradierDavid Pradier
    Nov 21, 2002 at 9:29 am
    Nov 21, 2002 at 5:42 pm
  • Hi-- I have this rather long complex query that takes really long to complete (please see below). It seems like I ought to improve the speed somehow. I don't understand, for example, what the query ...
    Peter T. BrownPeter T. Brown
    Nov 15, 2002 at 7:53 pm
    Nov 15, 2002 at 8:08 pm
  • Hi all, I have developed a system that is composed of 10 separate running processes. Each of the processes opens a connection to postgres with the C interface. Whenever any process has to process any ...
    Nov 27, 2002 at 3:11 pm
    Nov 27, 2002 at 3:11 pm
  • Moving thread to pgsql-performance. Just run a regular vacuum once for the above. If you modify 10%+ of the table (via single or multiple updates, deletes or inserts) then a vacuum analyze will be ...
    Rod TaylorRod Taylor
    Nov 19, 2002 at 1:46 pm
    Nov 19, 2002 at 1:46 pm
Group Navigation
period‹ prev | Nov 2002 | next ›
Group Overview
grouppgsql-performance @

53 users for November 2002

Josh Berkus: 31 posts Tom Lane: 25 posts Scott.marlowe: 23 posts Andrew Sullivan: 14 posts Rod Taylor: 14 posts Pginfo: 13 posts Stephan Szabo: 12 posts Henrik Steffen: 11 posts Rajesh Kumar Mallah: 8 posts Wei Weng: 8 posts Nikk Anderson: 7 posts Typea: 6 posts Eric soroos: 6 posts Ron Johnson: 5 posts Shridhar Daithankar: 5 posts Björn Metzdorf: 4 posts Mike Nielsen: 4 posts Robert Treat: 4 posts Bruce Momjian: 3 posts Federico /* juri */ Pedemonte: 3 posts
show more