Re: [ADMIN] large table support 32,000,000 rows

I have multi tables with over 10,000, 000 rows, the biggest one is 70, 000, 000 rows. For each table, there are several indexes, almost all columns are varchar2. In my experiences, with many indexes on large table, data insertion will be a pain. In my case, I have 30, 000 rows to be inserted

Re: [ADMIN] seq scan on indexed column

, Anna Cc: '[EMAIL PROTECTED]' Subject: Re: [ADMIN] seq scan on indexed column On Thu, 14 Mar 2002, Zhang, Anna wrote: > gtld_analysis=# explain SELECT NETBLOCK_START > gtld_analysis-# FROM GTLD_OWNER > gtld_analysis-# WHERE NETBLOCK_START = -2147483648; You might want to try

FW: [ADMIN] seq scan on indexed column

zabo, Could you please take a look, I know you can help!!! Anna Zhang -Original Message- From: Zhang, Anna [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 3:34 PM To: '[EMAIL PROTECTED]' Subject: [ADMIN] seq scan on indexed column Hi, I always have question

[ADMIN] seq scan on indexed column

Hi, I always have questions on sql tunning, here is the one: gtld_analysis=# \d gtld_owner Table "gtld_owner" Attribute| Type | Modifier ++ owner_name | character varying(100) | netblock_star

Re: [ADMIN] vacuum error

Thanks Stephan! your suggestion works. I just wonder that if dropping triggers caused such problem, this might be a postgres bug. Anna Zhang -Original Message- From: Stephan Szabo [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 1:02 PM To: Zhang, Anna Cc: '[EMAIL PROT

[ADMIN] vacuum error

Hi, I got an error when vacuum database, see below: $vacuumdb xdap ERROR: RelationBuildTriggers: 2 record(s) not found for rel domain. I deleted triggers that referenced domain before vacuum, is this the cause? How can I fix it? or It doesn't bother, It's ok to ignore such error? Thanks in adva

[ADMIN] fk constraint can't be dropped

Hi, I created a foreign key constraint on table referral like this: alter table referral add constraint fk_referral foreign key (handle) references domain (handle); create alter table referral drop constraint fk_referral restrict; ERROR: ALTER TABLE / DROP CONSTRAINT: fk_referral does not exist.

[ADMIN] pgaccess of postgres 7.2

Hi, I installed postgres 7.2 to default location. I can't find pgaccess. Does this utility has to install seperately? or I installed wrong? Someone knows? For my postgres 7.1.3 database, pgaccess works fine. ---(end of broadcast)--- TIP 1: subs

Re: [ADMIN] optimizer

>Is the estimate above (1.5M rows) reasonable? If so, it's probably >doing the right thing. If not, what version are you using and are >there any very common values that may throw off the estimates; what >does select * from pg_statistic where starelid=(select oid from >pg_class where relname='d

[ADMIN] optimizer

Hi, I have a table named Domain that has 14M rows, here is the defination: xdap_regr=# \d domain Table "domain" Attribute | Type | Modifier -+---+-- domainhandle| text |not null domainname | text |not null parentdomain| text |

[ADMIN] shared_buffers and effective_cache_size

Hi, I just got a new Penguin machine with 2 processors and 2G RAM. After installed postgres 7.2, I started to modify postgresql.conf to get max performance. I read Adm Guide and Bruce's article: PostgreSQL Hardware Performance Tuning, in my understanding, shared_buffers is similar to Oracle's db_b

Re: [ADMIN] postgresql 7.1.3

try: $tar xzpf postgresql-7.1.3.tar.gz Anna Zhang -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 12:51 PM To: [EMAIL PROTECTED] Subject: [ADMIN] postgresql 7.1.3 Hi, I have postgresql7.1.2 on system now(sunOs5.6). I downloaded po

Re: [ADMIN] tuning SQL

takes only a few minues. Thanks! Anna Zhang -Original Message- From: Ross J. Reedstrom [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 11:39 AM To: Zhang, Anna Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] tuning SQL On Tue, Jan 29, 2002 at 10:57:01AM -0500, Zhang, Anna wrote

[ADMIN] tuning SQL

Hi, I am running a query on postgres 7.1.3 at Red Hat 7.2 (2 CPUs, 1.5G RAM, 2 drive disk array). select count(*) from contact a, contact_discard b where a.contacthandle <> b.contacthandle; Table contact has over 9 million rows, contact_diacard has around 259,000 rows, both tables define contac

Re: [ADMIN] Increasing Shared Memory - on MacOS X

see docs: http://www.postgresql.org/idocs/ under Administrator's Guide, section 3.5 Managing Kernel Resources. Anna Zhang -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 9:06 PM To: Chris Ruprecht Cc: PostGreSQL Admin Group Subject: Re: [ADM

Re: [ADMIN] Increasing Shared Memory - on MacOS X

You need to increase SHMMAX. For solaris, it's in /etc/system file; Linux: /etc/sysctl.conf. You should know corresponding file for your system or check with your SA to figure out. Anna Zhang -Original Message- From: Chris Ruprecht [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2

Re: [ADMIN] ERROR: cannot read block

I think you have experienced data/index block corruption. First drop indexes (if you have) and recreate them. if only index corrupts, you are lucky, this will fix your problem. but if this won't work, it means that data block corrupted, you may need to recovery your database using backup. Above s

[ADMIN] timing a process

Hi All, I like to know how to timing a process? like in oracle sqlplus, we can set timing on, then execute a statement, such way we can know how long the process takes. In psql, is there such feature? Anna Zhang ---(end of broadcast)--- TIP 4: Do

[ADMIN] copy command

I have a problem to load data to postgres database using copy command. The problem is that we have one column called address which is multi-line text, the taxt file looks like this: aab770|awkc.com administration|sultan 23 Bogota, na0|CO above shows one record with '|' as delimiters. Column

[ADMIN] poor performance of loading data

I just installed Postgres 7.1.3 on my Red Hat 7.2 linux box. We are doing research to see how postgres doing, I used copy utility to import data from a text file which contains 32 mils rows, it has been 26 hours passed, but still running. My question is how postgres handles such data loading? it