FAQ

PostgreSQL > pgsql-performance > September 2005

Search Discussions

71 discussions - 463 posts

  • As a thought exeriment, I've been considering the best way to sort 1TB (2^40B) of 2-4KB (2^11-2^12B) records. That's 2^28-2^29 records. Part I: A Model of the System The performance of such external ...
    Ron PeacetreeRon Peacetree
    Sep 26, 2005 at 5:47 pm
    Sep 30, 2005 at 11:52 pm
  • Hi, I'm having performance issues with a table consisting of 2,043,133 rows. The schema is: \d address Table "public.address" Column | Type | Modifiers ...
    Matthew SackmanMatthew Sackman
    Sep 1, 2005 at 5:42 pm
    Sep 6, 2005 at 3:51 pm
  • ... to do the following: (1) Make a table memory-resident only ? (2) Set up user variables in memory that are persistent across all sessions, for as long as the database is up and running ? (3) ...
    Lane Van IngenLane Van Ingen
    Sep 29, 2005 at 11:21 pm
    Oct 25, 2005 at 12:50 am
  • It looks like a rebranded low end Adaptec 64MB PCI-X <- SATA RAID card. Looks like the 64MB buffer is not upgradable. Looks like it's SATA, not SATA II There are much better ways to spend your money. ...
    Ron PeacetreeRon Peacetree
    Sep 24, 2005 at 3:56 pm
    Sep 29, 2005 at 2:24 pm
  • I'm converting a relatively small database (2 MB) from MySQL to PostgreSQL. It is used to generate web pages using PHP. Although the actual website runs under Linux, the development is done under XP. ...
    JoeJoe
    Sep 29, 2005 at 3:05 am
    Oct 4, 2005 at 11:20 pm
  • Hi, I've got many queries running much slower on 8.1 beta2 than on 8.0.1 Here is a simplified one that takes 484 ms on 8.1 and 32 ms on 8.0.1. select from Content C left outer join Supplier S on ...
    Jean-Pierre PelletierJean-Pierre Pelletier
    Sep 22, 2005 at 9:20 pm
    Sep 23, 2005 at 1:41 am
  • I'm in the process of developing an application which uses PostgreSQL for data storage. Our database traffic is very atypical, and as a result it has been rather challenging to figure out how to best ...
    Brandon BlackBrandon Black
    Sep 12, 2005 at 9:04 pm
    Sep 21, 2005 at 4:02 pm
  • Hi, I must convert an old table into a new table. The conversion goes at ~ 100 records per second. Given the fact that I must convert 40 million records, it takes too much time: more hours than the ...
    Joost KraaijeveldJoost Kraaijeveld
    Sep 23, 2005 at 6:49 am
    Sep 23, 2005 at 3:31 pm
  • I have concerns about whether we are overallocating memory for use in external sorts. (All code relating to this is in tuplesort.c) When we begin a sort we allocate (work_mem | maintenance_work_mem) ...
    Simon RiggsSimon Riggs
    Sep 23, 2005 at 9:37 am
    Sep 25, 2005 at 5:45 pm
  • Hello. I would like to build a shared repository for Enterprise Architect (http://www.sparxsystems.com.au/ea.htm) using PostgreSQL. I have done it before with Linux and FreeBSD servers and everything ...
    Dalibor SramekDalibor Sramek
    Sep 13, 2005 at 11:05 am
    Sep 14, 2005 at 5:10 pm
  • unsubscribe
    Richard WooRichard Woo
    Sep 20, 2005 at 1:50 pm
    Sep 27, 2005 at 4:21 pm
  • I have about 419804 rows in my article table. I have installed tsearch2 and its gist index correctly. My table structure is: CREATE TABLE tbarticles ( articleid int4 NOT NULL, title varchar(250), ...
    Ahmad FajarAhmad Fajar
    Sep 21, 2005 at 10:04 pm
    Sep 25, 2005 at 9:03 pm
  • Hi all, I have been "googling" a bit searching info about a way to monitor postgresql (CPU & Memory, num processes, ... ) and I haven't found anything relevant. I'm using munin to monitor others ...
    ArnauArnau
    Sep 28, 2005 at 2:32 pm
    Sep 30, 2005 at 8:57 pm
  • Hi, I usually use PostgreSQL coupled with Linux, but I have to use Windows for a perticular project. So I wanted to do some tests to know if the performance will be acceptable (I don't need ...
    Marc CousinMarc Cousin
    Sep 6, 2005 at 2:12 pm
    Sep 7, 2005 at 3:02 pm
  • Hi, I'm using inherited tables to partition some data which can grow very large. Recently I discovered that a simple query that on a regular table would use an index was instead using seq scans (70s ...
    Matteo BeccatiMatteo Beccati
    Sep 2, 2005 at 10:20 am
    Sep 2, 2005 at 8:08 pm
  • Folks, I'm getting a new server for our database, and I have a quick question about RAID controllers with a battery backed cache. I understand that the cache will allow the cache to be written out if ...
    Peter DarleyPeter Darley
    Sep 14, 2005 at 6:22 pm
    Sep 14, 2005 at 9:58 pm
  • Hello all! On my master course, I'm studying the PostgreSQL's optimizer. I don't know if anyone in this list have been participated from the PostgreSQL's Optimizer development, but maybe someone can ...
    Pryscila B GuttoskiPryscila B Guttoski
    Sep 13, 2005 at 10:50 pm
    Sep 14, 2005 at 3:20 am
  • Hello, We are seeing a very strange behavior from postgres. For one of our very common tasks we have to delete records from a table of around 500,000 rows. The delete is by id which is the primary ...
    Brian ChoateBrian Choate
    Sep 6, 2005 at 3:04 pm
    Sep 7, 2005 at 9:38 pm
  • Hi While doing some stress testing for updates in a small sized table we found the following results. We are not too happy about the speed of the updates particularly at high concurrency (10 ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Sep 28, 2005 at 12:27 pm
    Oct 4, 2005 at 6:55 pm
  • Hi Everyone The machine is IBM x345 with ServeRAID 6i 128mb cache and 6 SCSI 15k disks. 2 disks are in RAID1 and hold the OS, SWAP & pg_xlog 4 disks are in RAID10 and hold the Cluster itself. the DB ...
    Bm\\mbnBm\\mbn
    Sep 16, 2005 at 11:51 am
    Sep 20, 2005 at 3:13 pm
  • Hi. I have an interesting problem with the JDBC drivers. When I use a select like this: "SELECT t0.aktiv, t0.id, t0.ist_teilnehmer, t0.nachname, t0.plz, t0.vorname FROM public.dga_dienstleister t0 ...
    Guido NeitzerGuido Neitzer
    Sep 1, 2005 at 11:09 pm
    Sep 12, 2005 at 3:30 pm
  • Hi! I've set up a Package Cluster ( Fail-Over Cluster ) on our two HP DL380 G4 with MSA Storrage G2.( Xeon 3,4Ghz, 6GB Ram, 2x 36GB@15rpm- Raid1) The system is running under Suse Linux Enterprise ...
    Ernst EinsteinErnst Einstein
    Sep 1, 2005 at 12:16 pm
    Sep 4, 2005 at 5:20 pm
  • Hello all, I have table ma_data, that contain above 300000 rows. This table has primary key id, and field alias_id. I create index (btree)on this field. Set statistic: ALTER TABLE "public"."ma_data" ...
    Andrey RepkoAndrey Repko
    Sep 27, 2005 at 9:15 am
    Sep 27, 2005 at 2:35 pm
  • Is there an performance benefit to using int2 (instead of int4) in cases where i know i will be well within its numeric range? I want to conserve storage space and gain speed anywhere i can, but i ...
    AnnounceAnnounce
    Sep 26, 2005 at 5:53 pm
    Sep 26, 2005 at 11:00 pm
  • Hi all, I have the following table: espsm_asme=# \d statistics_sasme Table "public.statistics_sasme" Column | Type | Modifiers ...
    ArnauArnau
    Sep 2, 2005 at 11:43 am
    Sep 12, 2005 at 5:06 am
  • Hi again, first I want to say ***THANK YOU*** for everyone who kindly shared their thoughts on my hardware problems. I really appreciate it. I started to look for a new server and I am quite sure ...
    Ulrich WisserUlrich Wisser
    Sep 1, 2005 at 1:23 pm
    Sep 1, 2005 at 5:30 pm
  • Hello, We are using postgresql in a search engine on an intranet handling throusand of documents. But we ave a big problem when users use more than two search key. There are more tables around, but ...
    Antoine BajoletAntoine Bajolet
    Sep 17, 2005 at 3:47 pm
    Sep 22, 2005 at 5:53 pm
  • Which is faster, where the list involved is fixed? My thought is that since it doesn't have to check a seperate table, the CHECK itself should be the faster of the two, but I can't find anything that ...
    Marc G. FournierMarc G. Fournier
    Sep 10, 2005 at 3:23 am
    Sep 21, 2005 at 3:35 pm
  • has jfs been reliable for you? there seems to be a lot of conjecture about instability, but i find jfs a potentially attractive alternative for a number of reasons. richard
    Welty, RichardWelty, Richard
    Sep 20, 2005 at 3:21 pm
    Sep 20, 2005 at 6:29 pm
  • Hi list, I don't have much experience with Postgres optimization, somehow I was happily avoiding anything more difficult than simple select statement, and it was working all right. Now LEFT JOIN must ...
    Ksenia MarasanovaKsenia Marasanova
    Sep 11, 2005 at 5:13 pm
    Sep 12, 2005 at 10:37 am
  • Hello, I'm a newbie in postgresql, I've installed it on a Windows XP machine ( I can't use linux, it's a company machine ), I'm courious why this query takes so long SELECT "Rut Cliente" FROM ...
    Christian CompagnonChristian Compagnon
    Sep 7, 2005 at 4:22 pm
    Sep 7, 2005 at 6:41 pm
  • Hello, We have been experiencing poor performance of VACUUM in our production database. Relevant details of our implementation are as follows: 1. We have a database that grows to about 100GB. 2. The ...
    Jan PetersonJan Peterson
    Sep 4, 2005 at 6:16 am
    Sep 7, 2005 at 1:07 am
  • Hi, Is there a way to improve the performance of the following query? SELECT * FROM SSIRRA where (YEAR = 2004 and CUSTOMER = 0000000004 and CODE = 00 and PART = 00) or (YEAR = 2004 and CUSTOMER = ...
    Carlos BenkendorfCarlos Benkendorf
    Sep 3, 2005 at 9:02 pm
    Sep 6, 2005 at 2:47 pm
  • If I do a simple query like: Select ids, keywords from dict where keywords='blabla' ('blabla' is a single word); The table have 200 million rows, I have index the keywords field. On the first time my ...
    Ahmad FajarAhmad Fajar
    Sep 25, 2005 at 6:38 pm
    Oct 3, 2005 at 8:04 pm
  • Am trying to port a mysql statement to postgres. Please help me in finding the error in this, CREATE SEQUENCE ai_id; CREATE TABLE badusers ( id int DEFAULT nextval('ai_id') NOT NULL, UserName ...
    R, Rajesh (STSD)R, Rajesh (STSD)
    Sep 29, 2005 at 1:05 pm
    Sep 30, 2005 at 11:48 pm
  • Hi All, Can anyone please tell/point me where I can get the postgresql system layout (I've an interest to contribute). I would also like to know the files involved for performing each task ( for eg ...
    Gnanavel SGnanavel S
    Sep 27, 2005 at 9:50 am
    Sep 27, 2005 at 2:20 pm
  • I have a database of hundreds of millions of web links (between sites) in Postgres. For each link, we record the url, the referer, and the most recent date the link exists. I'm having some serious ...
    CydatamattCydatamatt
    Sep 13, 2005 at 8:24 pm
    Sep 20, 2005 at 4:22 am
  • Hello everyone I must be doing something very wrong here so help please! I have two tables tableA has 300,000 recs tableB has 20,000 recs I need to set the value of a field in table A to a value in ...
    Hilary ForbesHilary Forbes
    Sep 12, 2005 at 9:11 am
    Sep 12, 2005 at 2:07 pm
  • Hello, My company has decided to migrate our Oracle database to postgresql8. We will aquire a new server for this, and would very much appreciate your advice. NOTE: The applications accessing the ...
    Christian KastnerChristian Kastner
    Sep 5, 2005 at 1:50 pm
    Sep 7, 2005 at 5:06 pm
  • Hi list, i'm a postgres noob and before designing a new Database Schema i would like to ask you a simple question because preformance will be a critical point. My question regards performance ...
    XchrisXchris
    Sep 30, 2005 at 9:16 am
    Oct 4, 2005 at 9:01 pm
  • Something interesting is going on. I wish I could show you the graphs, but I'm sure this will not be a surprise to the seasoned veterans. A particular application server I have has been running for ...
    Matthew NuzumMatthew Nuzum
    Sep 28, 2005 at 8:02 pm
    Oct 4, 2005 at 8:19 pm
  • Hello pals, I have the following table in Postgresql 8.0.1 Mydb# \d geoip_block Table "public.geoip_block" Column | Type | Modifiers -------------+--------+----------- locid | bigint | start_block | ...
    Cristian PrietoCristian Prieto
    Sep 23, 2005 at 10:05 pm
    Sep 26, 2005 at 7:17 pm
  • Hello! Got a DB with traffic statictics stored. And a SELECT statement which shows traffic volume per days also divided by regions - local traffic and global. Thus SELECT statement returns about some ...
    eVleVl
    Sep 22, 2005 at 10:27 pm
    Sep 24, 2005 at 3:09 am
  • I have a query that looks roughly like this (I've removed irrelevant SELECT clause material and obfuscated names, trying to keep them consistent where altered in EXPLAIN output): SELECT ...
    Thomas F. O'ConnellThomas F. O'Connell
    Sep 19, 2005 at 11:00 pm
    Sep 20, 2005 at 5:37 am
  • Hello all, Mostly Postgres makes sense to me. But now and then it does something that boggles my brain. Take the statements below. I have a table (agent) with 5300 rows. The primary key is agent_id. ...
    Martin NickelMartin Nickel
    Sep 17, 2005 at 1:28 am
    Sep 19, 2005 at 11:08 pm
  • Hello All, We are struggling with a specific query that is killing us. When doing explain analyze on the entire query, we *seem* to be getting killed by the estimated number of rows on a case ...
    Chris KratzChris Kratz
    Sep 13, 2005 at 9:08 pm
    Sep 14, 2005 at 1:35 pm
  • Hi. I have a performance problem with prepared statements (JDBC prepared statement). This query: PreparedStatement st = conn.prepareStatement("SELECT id FROM dga_dienstleister WHERE plz like ...
    Guido NeitzerGuido Neitzer
    Sep 11, 2005 at 8:29 am
    Sep 11, 2005 at 10:35 am
  • please help me , comment on postgresql (8.x.x) performance on cpu AMD, INTEL and why i should use 32 bit or 64 cpu ? (what the performance difference) thank you Express yourself instantly with MSN ...
    Wisan watcharinpornWisan watcharinporn
    Sep 9, 2005 at 5:54 am
    Sep 10, 2005 at 5:40 am
  • Hi all. In a cluster, is there any way to use the main memory of the other nodes instead of the swap? If I have a query with many sub-queries and a lot of data, I can easily fill all the memory in a ...
    Ricardo HumphreysRicardo Humphreys
    Sep 2, 2005 at 1:04 am
    Sep 2, 2005 at 11:18 am
  • Hi All, I have a SQL function like : CREATE OR REPLACE FUNCTION fn_get_yetkili_inisyer_listesi(int4, int4) RETURNS SETOF kod_adi_liste_type AS $BODY$ SELECT Y.KOD,Y.ADI FROM T_YER Y WHERE EXISTS ...
    AdnandursunAdnandursun
    Sep 29, 2005 at 7:55 pm
    Oct 4, 2005 at 8:52 pm
Sep 2005
12
Group Navigation
period‹ prev | Sep 2005 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions71
posts463
users142
websitepostgresql.org
irc#postgresql

142 users for September 2005

Tom Lane: 36 posts Ron Peacetree: 27 posts Merlin Moncure: 21 posts Pierre-Frédéric Caillaud: 11 posts Richard Huxton: 11 posts Simon Riggs: 11 posts Josh Berkus: 10 posts Matthew Sackman: 10 posts Jean-Pierre Pelletier: 9 posts K C Lau: 9 posts John Arbash Meinel: 8 posts Luke Lonergan: 8 posts Michael Fuhr: 7 posts Michael Stone: 7 posts Ahmad Fajar: 6 posts Alvaro Herrera: 6 posts Chris Browne: 6 posts Gavin Sherry: 6 posts Joe: 6 posts Steinar H. Gunderson: 6 posts
show more
Archives