Re: [GENERAL] failure with pg_dump

. I know the clients are not having problems since they've been stable for a long time. I'm guessing nobody else is seeing arbitrary connection drops in 8.0.1, particularly on FreeBSD 5.4-PRERELEASE :-( Funny thing is that the pg_dump worked yesterday... Vivek Khera, Ph.D. +1-301-869-4449 x806

Re: [GENERAL] Ways to speed up dumpreload

. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end of broadcast)--- TIP 3: if posting/reading through

Re: [GENERAL] pgpool simple feature request

? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end of broadcast)--- TIP 6: Have you searched

Re: [GENERAL] Safely Killing Backends

. Effectively, it does the moral equivalent of unplugging the power cord and restarting itself, without the bother of needing to reboot the whole machine :-) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: khera

Re: [GENERAL] Long-running performance (MVCC, Vacuum, etc.) - Any fix?

of the db pretty constant. ie, it doesn't grow without bounds, as the OP fears. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y

Re: [GENERAL] increasing max_connections on freebsd

check if MF the settings you posted also work in FreeBSD 4. Thanks. Yes, they do. You can also bump maxfiles if necessary via a sysctl. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL

Re: [GENERAL] What HW / OS is recommeded

. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end of broadcast

Re: [GENERAL] What HW / OS is recommeded

. Hate to burst your bubble, but the RAID controller that Dell ships is an Adaptec OEM. Dell just rebrands them. They also rebrand LSI. I'm saying that the versions they sell don't seem to perform as well as the manufacturer branded ones from what I've compared with other folks. Vivek Khera, Ph.D

Re: [GENERAL] What HW / OS is recommeded

On Dec 22, 2004, at 1:09 PM, Scott Marlowe wrote: I've use the Dell PERC 4DC and had VERY good performance from it. IT's the late model U320 LSI MegaRAID and runs great. I do remember that the 2650 and few other Dells had the serverworks chipset in them that caused a lot of context switches in

Re: [GENERAL] disabling constraints

like: Why don't you truncate your tables in an order that won't violate FK's? Or do you have circular references? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD

Re: [GENERAL] routine reindexing in 7.4.6/8.0?

needed to reindex once per month or so. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org

Re: [GENERAL] 8.0 questions

is likely to be more if you split the changes. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http

Re: [GENERAL] Random not so random

. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end of broadcast)--- TIP 9

Re: [GENERAL] dangling permission on tables after drop user.

rid of that user and all the grants? DROP USER ends up with the dangling GRANTs still hanging about. Is there no way to drop a user and have the necessary grants disappear? How does one drop a user cleanly? Vivek Khera, Ph.D. +1-301-869-4449 x806 smime.p7s Description: S/MIME cryptographic

[GENERAL] dangling permission on tables after drop user.

to an ascii file and delete those GRANT lines, but the compressed dump is over 2Gb for this database. Vivek Khera, Ph.D. +1-301-869-4449 x806 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe

Re: [GENERAL] dangling permission on tables after drop user.

On Sep 29, 2004, at 4:55 PM, Richard Huxton wrote: Vivek Khera wrote: there is no user with ID 102 in the pg_user view. pg_restore complains about the missing user 102. And no, the user was not 102 it was the name of a (former) employee. The gross hack is to pg_restore to an ascii file

Re: [GENERAL] disk performance benchmarks

a 14 spindle RAID in software? :-) Battery backed write-back cache is definitely mandatory for performance. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301

Re: [GENERAL] disk performance benchmarks

. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end

Re: [GENERAL] disk performance benchmarks

, and disk speed are the major factors. That and your schema needs to be not idiotic. :-) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM

Re: [GENERAL] Best practices for migrating a development database to a

1.5 hours or less. You really have to take each situation separately. The easy way of the PK adding script works fine on tables up to about 60k or 100k rows, so we used that on some other smaller tables. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D

Re: [GENERAL] How to determine a database is intact?

is on 100Mbit). -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek

Re: [GENERAL] Foreign key locks

that means all of them, but I wanted to be sure. Thanks! -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera

Re: [GENERAL] How is this possible? (more on deadlocks)

. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end

Re: [GENERAL] Deadlocks caused by referential integrity checks

with that, since the other transaction is usually more expensive. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera

Re: [GENERAL] Replication options?

to solve my main problem with multi-million row tables, but it did work on a small production database with a few hundred rows just fine (albeit with 200MB+ memory footprint!) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera

Re: [GENERAL] max_fsm_pages

configuration suffice? Downtime is hard for me ;-) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http

Re: [GENERAL] Is there a newer version of DBD::Pg?

sticking with DBD::Pg 1.22 since it is completely stable for me. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera

Re: [GENERAL] Perl DBIx::SearchBuilder and pg_atoi: zero-length string?

of SearchBuilder. I'd file a but report either via CPAN (www.cpan.org) or with the author directly. He's pretty good getting these things fixed. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL

Re: [GENERAL] Question on Opteron performance

before the CPUs. I know I certainly do, even with 4GB RAM and a fair number of shared buffers. Dual CPUs are more then plenty for our usage patterns. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL

Re: [GENERAL] DBD::Pg 1.32 ready for testing

? I never got any ack that it was. See https://rt.cpan.org/NoAuth/Bug.html?id=4996 It was most fun tracking that one down! I'll dl and test 1.32 tomorrow... EOD here now. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera

Re: [GENERAL] Quad Xeon vs. Dual Itanium

that the box will be running *only* the database and any other applications will run elsewhere. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-301-869-4449 x806 AIM

Re: [GENERAL] FW: Postgres 7.4 runing on BSD

then follow the normal install instructions. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org

Re: [GENERAL] FW: Postgres 7.4 runing on BSD

LR == Larry Rosenman [EMAIL PROTECTED] writes: LR PORTNAME?= postgresql LR PORTVERSION?= 7.4 LR PORTREVISION?= 0 LR I did :-0) I stand outdated ;-) ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index

Re: [GENERAL] Upgrading from 7.2.3 to....??

daily. I'm very happy with it. You will be to :-) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http

Re: [GENERAL] database speed

. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end of broadcast)--- TIP 4: Don't

Re: [GENERAL] VACUUM degrades performance significantly. Database becomes

PostgreSQL for over 3 years now and IIRC VACUUM Your CPU usage is irrelevent here. What's your *disk* utilization. Does linux have systat and/or iostat to tell you how busy your disks are? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D

Re: [GENERAL] Table partitioning for maximum speed?

to the table). Your table splitting solution sounds like something I'd do if I were forced to use mysql ;-) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240

Re: [GENERAL] Table partitioning for maximum speed?

JL == Jean-Luc Lachance [EMAIL PROTECTED] writes: JL BULL. JL How many times does PG have to scan the whole table because of MVCC? JL At least with partitioning there is a fighting chance that that won't be JL necessary. Huh? His specific query was WHERE md5 = ''. Why on earth would that

Re: [GENERAL] Humor me: Postgresql vs. MySql (esp. licensing)

corrupted. Assuming proper fsyncing of your hard sm drives (i.e. SCSI, or IDE with write cache disabled) So you're saying it is not possible to corrupt the WAL if the process is ungracefully killed by the OS? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D

Re: [GENERAL] pg_restore takes ages

. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end of broadcast

Re: [GENERAL] pg_restore takes ages

sm == scott marlowe scott.marlowe writes: sm also, turning off fsync during the load helps a lot. Be sure to turn it sm back on when you're done of course. Only if you don't have a battery-backed cache on your RAID. If you do, it won't likely make a big difference. For me it was about 2

Re: [GENERAL] State of Beta 2

MGF == Marc G Fournier [EMAIL PROTECTED] writes: MGF Without a fair amount of testing, especially on other platforms, it most MGF likely won't happen in the distribution itself ... one of the things that MGF was bantered around for after v7.4 is released is seeing how increasing it MGF on the

Re: [GENERAL] A Question About Insertions -- Performance

BM == Bruce Momjian [EMAIL PROTECTED] writes: Check your logs to see if you are checkpointing too frequently. BM That warning message is only in 7.4. Yes, but the checkpoint activity is still logged. On my 7.2 system, I'm checkpointing about every 1.5 minutes at peak with 3 checkpoint

Re: [GENERAL] State of Beta 2

. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end of broadcast)--- TIP 3

Re: [GENERAL] Backup?

with just the PK, but the cost savings on mass inserts which happen often offset this immensely, not to mention 1Gb of disk which never needs to be read into the buffers ;-) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera

Re: [GENERAL] Backup?

of them. ie, the copy is non-atomic, and there is no guarantee that all data is flushed to disk. i don't even do a file system dump of my PG data partition because of this. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera

Re: [GENERAL] What is the good equivalent for ENUM ?

whatever ( ...  status varchar(10) NOT NULL DEFAULT 'active' REFERENCES status_levels(status), ... ); -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240

Re: [GENERAL] Commercial postgresql

and drop the old one inside a transaction. What about the primary keys? How do you create a new primary key without first dropping the old one? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL

Re: [GENERAL] Commercial postgresql

. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end of broadcast

Re: [GENERAL] Commercial postgresql

it. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end of broadcast)--- TIP 5: Have you checked our

Re: [GENERAL] Commercial postgresql

BL == Bo Lorentsen [EMAIL PROTECTED] writes: BL On Tue, 2003-09-02 at 04:08, Vivek Khera wrote: I use it in 24/7/365 system which is heavily written to and read from. The drawbacks I have are: BL How depressing, may I ask that PG version you are using ? Currently 7.2 in production, 7.4b2

Re: [GENERAL] Linux ready for high-volume databases?

AH == Alvaro Herrera [EMAIL PROTECTED] writes: AH On Wed, Aug 27, 2003 at 12:21:53PM -0400, Vivek Khera wrote: GS == Greg Stark [EMAIL PROTECTED] writes: GS Vivek Khera [EMAIL PROTECTED] writes: GS Oh, it's a really small database. That helps a lot with the backup GS problems of 24x7

Re: [GENERAL] Linux ready for high-volume databases?

of 24x7 operation. Still I would be interested. Ok... so I re-read my post. I mean 27Gb on disk. Duh. Sorry for the confusion! -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED

Re: [GENERAL] Linux ready for high-volume databases?

dump of the PG data partition. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek

Re: [GENERAL] Buglist

BM == Bruce Momjian [EMAIL PROTECTED] writes: Well, did I mention I'm saturating my disk I/O bandwidth at the same time with other queries? ;-) BM But six hours. It is my understanding that a sequential scan is roughly BM the same load as a non-FULL vacuum. Are you saying a sequential

Re: [GENERAL] Buglist

... -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end of broadcast)--- TIP 9

Re: [GENERAL] Buglist

BW == Bruno Wolff, Bruno writes: to see it incremental. This would result in pretty much near zero internal fragmentation, I think. BW Why do you care about about the details of the implementation (rather than BW the performance)? If it were faster to do it that way, that's how it would BW

Re: [GENERAL] Buglist

and freeing it. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek

Re: [GENERAL] Buglist

MTO == Matthew T O'Connor [EMAIL PROTECTED] writes: MTO talking beyond my real knowledge MTO Changing Postgres to perform as mentioned above is non-trivial, it would MTO basicially change the entire core of the system. I think this is due to MTO the fact that postgres uses a non-overwriting

Re: [GENERAL] dump_all/restore times?

BM == Bruce Momjian [EMAIL PROTECTED] writes: BM Here is an applied patch that suggests increasing sort_mem during BM restore. I though of putting it near the database restore section or in BM the manual, but is seemed more centralized to put it near the actual BM parameter. But nobody will

[GENERAL] what's going on with this list?

Three times this week I've been switched from nomail to getting mail for this group. Mail to [EMAIL PROTECTED] seems to be a black hole. I don't need this cluttering my mailbox when I read it via news. None of the other lists is doing this to me! ---(end of

[GENERAL] news server access down?

of problem on the web site, so I assume the service is still offered. Thanks. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera

[GENERAL] Re: error starting postmaster

-- -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end of broadcast)--- TIP 1

[GENERAL] Re: very big problem with NULL

. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end of broadcast

[GENERAL] turning off stderr message for postmaster

? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---(end of broadcast

[GENERAL] Re: Preventing variables from rolling over

you'll only find out after the fact, but the table will not have been updated in any case. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497

Re: [GENERAL] cast bit to boolean?

RH == Robert Hentosh [EMAIL PROTECTED] writes: RH select * from t1 where (sel_a b'11' b'00' ); Yep. That solution hit me just as the head hit the pillow last night, too! Thanks. ---(end of broadcast)--- TIP 1: subscribe and

[GENERAL] Re: mysql to Pgsql

binary attributes to char fields. delete any default NULL as they are redundant. text NOT NULL needs to have default '' for same behavior as in mysql. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet

[GENERAL] DBD::Pg errstr method doesn't return full error messages

Hi, I'm using DBD::Pg version 0.98 with Postgres 7.1. I'm noticing that quite often on an error, the $dbh-errstr method doesn't return the full error. For example, if I have a table with a unique key constraint: CREATE TABLE urls ( url_id SERIAL PRIMARY KEY, msg_id integer NOT NULL

[GENERAL] cast bit to boolean?

How might one case a BIT to a BOOLEAN? For example, I want to return rows which have non-zero bit representation for, say, (sel_a b'0011'). That is, rows with the first or second bit set. I tried an explicit CAST, and just the query directly, but the cast say you cant cast type 'bit' to

Re: [GENERAL] Can PostGreSQL handle 100 user database?

are wrong. The file size limit has to do with the data size of your file offset pointer. This is not necessarily a 32 bit quantity on a 32-bit processor. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Intern

<    1   2   3