FAQ

PostgreSQL > pgsql-performance > February 2003

Search Discussions

34 discussions - 245 posts

  • When defining data types, which is better text, varchar or char? I heard that on Postgres text is better, but I know on Sybase char is more efficient. Can someone please tell me whether this ...
    JeandreJeandre
    Feb 11, 2003 at 12:27 pm
    Mar 10, 2003 at 4:05 pm
  • I've a new configuration for our web server Processor Processeur Intel Xeon 2.0 Ghz / 512 Ko de cache L2 Memoiry 1 Go DDR SDRAM Disk1 18Go Ultra 3 (Ultra 160) SCSI 15 Ktpm Disk2 18Go Hot Plug Ultra 3 ...
    Philip johnsonPhilip johnson
    Feb 5, 2003 at 10:51 am
    Feb 12, 2003 at 11:52 am
  • Hi, I am having problems with my master database now. It used to work extremely good just two days ago, but then I started playing with adding/dropping schemas and added another database and ...
    Oleg LebedevOleg Lebedev
    Feb 21, 2003 at 4:27 pm
    Feb 25, 2003 at 4:50 pm
  • I've use PostgreSQL for some pretty amazing things, and was a proponent of using it here. I set up 7.3.1 on my development RedHat 8 box, and it was fine. I need to load about 700,000 rows into one ...
    Kevin WhiteKevin White
    Feb 21, 2003 at 3:34 pm
    Feb 25, 2003 at 11:50 pm
  • Hi Everyone, I've just spent the last day and a half trying to benchmark our new database installation to find a good value for wal_buffers. The quick answer - there isn't, just leave it on the ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Feb 13, 2003 at 5:16 am
    Feb 15, 2003 at 8:36 am
  • Hi there, Is there any performance tunning that i can make to the postgresql server to make the server more stable. In my case the main usage of the DB is from an website which has quite lots of ...
    CatalinCatalin
    Feb 27, 2003 at 12:19 pm
    Feb 28, 2003 at 2:29 pm
  • hello all, I am still fiddling around with my "big" database. System: RAM: 2GB CPU: 1,6 MHz (cache: 256 Kb) single disc: 120 GB :-( I have a query that joins to relatively large tables (10 - 15 Mio ...
    Chantal AckermannChantal Ackermann
    Feb 13, 2003 at 6:06 pm
    Feb 21, 2003 at 1:45 am
  • So let's say you were designing a tool to help someone get reasonable performance out of a PostgreSQL installation. What scenarios would you include in such a tool, and what information would you ...
    Kevin BrownKevin Brown
    Feb 14, 2003 at 5:31 am
    Feb 20, 2003 at 11:55 pm
  • Ryan, I am crossing this discussion to the PGSQL-PERFORMANCE list, which is the proper place for it. Anyone interested, please follow us there! First off, I'm not clear on why a duplicate anominaly ...
    Josh BerkusJosh Berkus
    Feb 18, 2003 at 5:38 pm
    Feb 20, 2003 at 11:31 am
  • Hi, I have following tables: with id as number(20,0): CREATE TABLE public.firm ( firm_id numeric(20, 0) NOT NULL, name varchar(40) NOT NULL, CONSTRAINT firm_pkey PRIMARY KEY (firm_id) ) with id as ...
    Rafal KedziorskiRafal Kedziorski
    Feb 16, 2003 at 11:03 pm
    Feb 17, 2003 at 8:04 pm
  • Hi !! We have "PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96" installed on Linux (RedHat 7.2) Our database size is 15 GB. Since the database size was increasing and was about to cross ...
    PRAGATI SAVAIKARPRAGATI SAVAIKAR
    Feb 26, 2003 at 6:27 am
    Mar 6, 2003 at 8:19 pm
  • Hello, We would like to use PostgreSQL for one project. This project would need to handle some of 150000 - 200000 (thousands records) per day. Is there somebody having experience with Postgresql in ...
    Jakab LaszloJakab Laszlo
    Feb 21, 2003 at 7:45 am
    Feb 23, 2003 at 8:46 pm
  • Darryl A. J. StaflundDarryl A. J. Staflund
    Feb 13, 2003 at 8:32 am
    Feb 14, 2003 at 12:35 pm
  • Folks, I have a new system with an Adaptec 2200S RAID controller. I've been testing some massive data transformations on it, and data write speed seems to top out at 3mb/second .... which seems slow ...
    Josh BerkusJosh Berkus
    Feb 18, 2003 at 9:45 pm
    Feb 27, 2003 at 6:32 pm
  • Folks: I'm not clear on where the memory needed by max_fsm_pages comes from. Is it taken out of the shared_buffers, or in addition to them? Further, Joe Conway gave me a guesstimate of 6k per ...
    Josh BerkusJosh Berkus
    Feb 24, 2003 at 6:55 pm
    Feb 24, 2003 at 9:33 pm
  • I come from a Sybase background and have just started working with Postgre. Are there any books or tutorials that cover general performance issues for beginners? I don't just want to start creating ...
    JeandreJeandre
    Feb 7, 2003 at 8:33 am
    Feb 7, 2003 at 5:21 pm
  • Hi I am doing some performance testing using postgresql. When measuring the latency of commit I got some results, which make me doubt, if the logging data is written to disk in time: Using a slow ...
    Matthias MeixnerMatthias Meixner
    Feb 20, 2003 at 8:42 am
    Mar 7, 2003 at 8:44 am
  • Hello, While testing multi-select views I found some problems. Here are details. I have 3 tables and I created a view on them: create view view123 as select key, value from tab1 where key=1 union all ...
    Mariusz CzuładaMariusz Czułada
    Feb 15, 2003 at 11:48 pm
    Feb 16, 2003 at 8:29 pm
  • Hello, I am going to do my best to describe this problem, but the description may be quite long. Also, this is my first post to this list, so I miss important details please let me know. All of the ...
    Scott CainScott Cain
    Feb 14, 2003 at 4:44 pm
    Feb 14, 2003 at 11:48 pm
  • Hi, we want to migrate from MS SQL Server (windows2000) to PostgreSQL (Linux) :-)) and we want to use the old MSSQL Hardware. Dual Pentium III 800 1 GB RAM 2 IDE 10 GB 2 RAID Controller (RAID 0,1 ...
    Schaefer, MarioSchaefer, Mario
    Feb 24, 2003 at 9:53 am
    Feb 24, 2003 at 7:22 pm
  • Question in brief: does the planner/optimizer take into account the foreign key constraints? If the answer is "no", please stop reading here. Here comes the details. Let me give a simple example to ...
    Anuradha RatnaweeraAnuradha Ratnaweera
    Feb 25, 2003 at 7:56 am
    Feb 26, 2003 at 5:40 am
  • Hello Everyone, I am having some problems getting my queries to use the correct index, and as a result they use a sequential scan that takes a very long time. The table in question is used for ...
    Mark HalliwellMark Halliwell
    Feb 25, 2003 at 10:40 am
    Feb 25, 2003 at 3:21 pm
  • Is there a TODO here, like "Allow recovery from corrupt pg_control via WAL"? --------------------------------------------------------------------------- Kevin Brown wrote: -- Bruce Momjian | ...
    Bruce MomjianBruce Momjian
    Feb 14, 2003 at 2:30 pm
    Feb 18, 2003 at 5:16 am
  • Tom, Thanks for your help in this. We have some flexibility in the schema design; we are going through our first PostGres performance testing now. Am I correct in interpreting your comments as saying ...
    SletovskySletovsky
    Feb 15, 2003 at 12:08 am
    Feb 15, 2003 at 8:36 pm
  • http://www.sndfocus.biz/go.cgi/foryou http://www.foreverstore.cjb.net Terima kasih atas waktu yang Anda luangkan untuk membaca email ini. Siapa tahu, ini akan mengubah kehidupan anda. Dalam ...
    Ahmad Abdul HaqAhmad Abdul Haq
    Feb 20, 2003 at 6:19 am
    Feb 20, 2003 at 10:06 am
  • hi, i have to set up a postgres database on a sun enterprise 10000 machine running on solaris 8. has anyone hints for tuning the database for me? regards -Chris -- If Bill Gates had a penny for every ...
    Christian ToeppChristian Toepp
    Feb 7, 2003 at 10:22 am
    Feb 7, 2003 at 10:59 am
  • I am interested in hearing from anyone that has used Postgres with the db files existing on a SAN, fibre channel or iSCSI. I would be interested in what hardware you used and what the performance ...
    Keith BottnerKeith Bottner
    Feb 5, 2003 at 4:16 pm
    Feb 5, 2003 at 5:59 pm
  • The query SELECT DISTINCT keycol, 'constant' FROM myTable or SELECT DISTINCT keycol, NULL FROM myTable will result in an error message (7.3.1) Unable to identify an ordering operator '<' for type ...
    Andreas PflugAndreas Pflug
    Feb 4, 2003 at 12:15 pm
    Feb 4, 2003 at 2:53 pm
  • Is there any way to see all the columns in the database? I have a column that needs to be changed in all the tables that use it, without having to check each table manually. In Sybase you would link ...
    Jeandre du ToitJeandre du Toit
    Feb 28, 2003 at 1:41 pm
    Feb 28, 2003 at 1:41 pm
  • hi all, we have a tsearch index on the following table: Table "public.sentences" Column | Type | Modifiers ---------------+---------+-------------------- sentence_id | bigint | not null puid | ...
    Chantal AckermannChantal Ackermann
    Feb 27, 2003 at 1:22 pm
    Feb 27, 2003 at 1:22 pm
  • [email protected] If you bought into our last recommendation (CIMG) early enough you had an excellent opportunity to make substantial gains (from .90 to 1.65 in just the first day). Now is ...
    IncomingforwardIncomingforward
    Feb 19, 2003 at 4:50 am
    Feb 19, 2003 at 4:50 am
  • Added to TODO: * Cache last known per-tuple offsets to speed long tuple access --------------------------------------------------------------------------- Tom Lane wrote: -- Bruce Momjian | ...
    Bruce MomjianBruce Momjian
    Feb 14, 2003 at 1:11 pm
    Feb 14, 2003 at 1:11 pm
  • While executing a lot of INSERTs and DELETEs, I had some performance problems which seemed to result from missing foreign key indexes. Unfortunately, if doing an EXPLAIN DELETE myTab .... I'm getting ...
    Andreas PflugAndreas Pflug
    Feb 4, 2003 at 3:16 pm
    Feb 4, 2003 at 3:16 pm
  • subscribe
    JeandreJeandre
    Feb 4, 2003 at 3:16 pm
    Feb 4, 2003 at 3:16 pm
Feb 2003
Group Navigation
period‹ prev | Feb 2003 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions34
posts245
users64
websitepostgresql.org
irc#postgresql

64 users for February 2003

Josh Berkus: 32 posts Tom Lane: 30 posts Christopher Kings-Lynne: 11 posts Andrew Sullivan: 10 posts Bruce Momjian: 9 posts Scott.marlowe: 8 posts Curt Sampson: 7 posts Justin Clift: 7 posts Shridhar Daithankar: 7 posts Andreas Pflug: 6 posts Jeandre du Toit: 6 posts Philip johnson: 6 posts Catalin: 5 posts Chantal Ackermann: 5 posts Manfred Koizar: 5 posts Rafal Kedziorski: 5 posts Robert Treat: 5 posts Eric soroos: 4 posts Kevin Brown: 4 posts Kevin White: 4 posts
show more
Archives