Re: [GENERAL] mild modification to pg_dump

What about the pgpass file? https://www.postgresql.org/docs/9.2/static/libpq-pgpass.html On 11/17/2017 03:06 PM, marcelo wrote: I need to "emulate" the pg_dump code because the password prompt. Years ago I write a program (for the QnX environment) that catched some prompt and emulates the

Re: [GENERAL] mild modification to pg_dump

On 11/17/2017 02:23 PM, John R Pierce wrote: On 11/17/2017 12:19 PM, marcelo wrote: Sorry, I was not exact. I don't need nor like to change pg_dump. Rather, based on pg_dump code, I need to develop a daemon which can receive a TCP message (from a privileged app) containing some elements: the

Re: [GENERAL] pg_restore load data

On 11/16/2017 03:13 PM, bricklen wrote: On Thu, Nov 16, 2017 at 1:07 PM, Ron Johnson <ron.l.john...@cox.net <mailto:ron.l.john...@cox.net>> wrote: v9.2.7  (Yes, I know, it's old.  Nothing I can do about it.) During a "whole database" restore using pg_re

[GENERAL] pg_restore load data

Hi, v9.2.7  (Yes, I know, it's old.  Nothing I can do about it.) During a "whole database" restore using pg_restore of a custom dump, when is the data actually loaded?  I've looked in the list output and don't see any "load" statements. Thanks -- World Peace Through Nuclear Pacification

[GENERAL] Converting AGE() to something human readable

Hi, How is this done in v8.4? postgres=# SELECT datname, datfrozenxid, age(datfrozenxid) postgres-# FROM pg_database;   datname  | datfrozenxid |    age ---+--+--- template1 |   3603334165 |  25735089 template0 |   3603470462 |  25598792 postgres  |   3576970250 | 

Re: [GENERAL] Old pg_clog files

On 10/29/2017 03:37 PM, David G. Johnston wrote: On Sunday, October 29, 2017, Ron Johnson <ron.l.john...@cox.net <mailto:ron.l.john...@cox.net>> wrote: Hi, v8.4.17 http://www.postgresql-archive.org/pg-clog-questions-td2080911.html <http://www.postgresql-arch

[GENERAL] Old pg_clog files

Hi, v8.4.17 http://www.postgresql-archive.org/pg-clog-questions-td2080911.html According to this old thread,  doing a VACUUM on every table in the postgres, template1 and TAPd databases should remove old pg_clog files. postgres=# SELECT datname, age(datfrozenxid) FROM pg_database;   datname 

Re: [GENERAL] Finally upgrading to 9.6!

On 10/18/2017 10:16 AM, Igal @ Lucee.org wrote: On 10/18/2017 7:45 AM, Ron Johnson wrote: On 10/18/2017 09:34 AM, Igal @ Lucee.org wrote: A bit off-topic here, but why upgrade to 9.6 when you can upgrade to 10.0? There's no way we're going to put an x.0.0 version into production

Re: [GENERAL] Finally upgrading to 9.6!

On 10/18/2017 09:34 AM, Igal @ Lucee.org wrote: On 10/18/2017 6:24 AM, Ron Johnson wrote: On 10/17/2017 11:17 AM, Tom Lane wrote: Ron Johnson <ron.l.john...@cox.net> writes: Where can I look to see (roughly) how much more RAM/CPU/disk needed when moving from 8.4 and 9.2? It's en

Re: [GENERAL] Finally upgrading to 9.6!

On 10/17/2017 11:17 AM, Tom Lane wrote: Ron Johnson <ron.l.john...@cox.net> writes: Where can I look to see (roughly) how much more RAM/CPU/disk needed when moving from 8.4 and 9.2? It's entirely possible you'll need *less*, as you'll be absorbing the benefit of several years'

[GENERAL] Finally upgrading to 9.6!

Where can I look to see (roughly) how much more RAM/CPU/disk needed when moving from 8.4 and 9.2? Thanks -- World Peace Through Nuclear Pacification -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Using cp to back up a database?

On 10/09/2017 01:02 PM, Scott Mead wrote: On Mon, Oct 9, 2017 at 1:19 PM, Ron Johnson <ron.l.john...@cox.net <mailto:ron.l.john...@cox.net>> wrote: Maybe my original question wasn't clear, so I'll try again: is it safe to do a physical using cp (as opposed to r

Re: [GENERAL] Using cp to back up a database?

reason the backup needs to be human-readable, this is the approach of choice as well. Darren The first On Mon, Oct 9, 2017 at 6:40 AM, Ron Johnson <ron.l.john...@cox.net <mailto:ron.l.john...@cox.net>> wrote: Hi, v8.4.20 This is what the current backup script use

Re: [GENERAL] Using cp to back up a database?

On 10/09/2017 11:33 AM, Jeff Janes wrote: On Mon, Oct 9, 2017 at 6:40 AM, Ron Johnson <ron.l.john...@cox.net <mailto:ron.l.john...@cox.net>> wrote: Hi, v8.4.20 This is what the current backup script uses: /usr/bin/psql -U postgres -c "SELECT

Re: [GENERAL] Using cp to back up a database?

rom: *<pgsql-general-ow...@postgresql.org> on behalf of Ron Johnson <ron.l.john...@cox.net> *Date: *Monday, October 9, 2017 at 8:41 AM *To: *"pgsql-general@postgresql.org" <pgsql-general@postgresql.org> *Subject: *[GENERAL] Using cp to back up a database? Hi, v8.4.20

[GENERAL] Using cp to back up a database?

Hi, v8.4.20 This is what the current backup script uses: /usr/bin/psql -U postgres -c "SELECT pg_start_backup('Incrementalbackup',true);" cp -r /var/lib/pgsql/data/* $dumpdir/data/ /usr/bin/psql -U postgres template1 -c "SELECT pg_stop_backup();" Should it use rsync or pg_dump instead?

Re: [GENERAL] Up to date conventional wisdom re max shared_buffer size?

On 09/20/2017 01:05 PM, Jerry Sievers wrote: Ron Johnson <ron.l.john...@cox.net> writes: On 09/19/2017 05:00 PM, Jerry Sievers wrote: [snip] The DB is 10TB total size with OLTP plus some occasional heavy batching which frequently correlates with degradation that requires interv

Re: [GENERAL] Up to date conventional wisdom re max shared_buffer size?

On 09/19/2017 05:00 PM, Jerry Sievers wrote: [snip] The DB is 10TB total size with OLTP plus some occasional heavy batching which frequently correlates with degradation that requires intervention. Unrelated server problem forced us to relocate from a Debian/Wheezy 3.x kernel 1T 144 CPU to the

Re: [GENERAL] Selecting a daily puzzle record - which type of column to add?

On 09/18/2017 08:17 AM, Melvin Davidson wrote: [snip] I don't have any specific suggestion for an additional column, other than Berend's idea. However, I strongly advise against the use of ENUM's. They can create a major problem in the event one needs to be removed. Because it will internally

Re: [GENERAL] "Canceling authentication due to timeout" with idle transaction and reindex

On 09/15/2017 06:34 AM, Justin Pryzby wrote: [snip] But you might consider: 1) looping around tables/indices rather than "REINDEX DATABASE", and then setting a statement_timeout=9s for each REINDEX statement; Is there a way to do that within psql? (Doing it from bash is trivial, but I'd

Re: [GENERAL] WAL & ready files retained after turning off log shipping

On 09/07/2017 09:32 AM, Tom Lane wrote: Ron Johnson <ron.l.john...@cox.net> writes: On 09/07/2017 09:08 AM, Tom Lane wrote: Manual cleanup shouldn't be very hard, fortunately. Run pg_controldata to see where the last checkpoint is, and delete WAL files whose names indicate they are

Re: [GENERAL] Joining 16 tables seems slow

On 09/12/2017 01:45 AM, Frank Millman wrote: Hi all I am using 9.4.4 on Fedora 22. I am experimenting with optimising a SQL statement. One version uses 4 LEFT JOIN’s and a 5-way CASE statement in the body. The second moves the filtering into the JOIN section, and I end up with 16 LEFT JOIN’s

[GENERAL] B-tree index on a VARCHAR(4000) column

Hi, v 9.2.7 Based on LENGTH(offending_column), none of the values are more than 144 bytes in this 44.2M row table. Even though VARCHAR is, by definition, variable length, are there any internal design issues which would make things more efficient if it were dropped to, for example,

Re: [GENERAL] WAL & ready files retained after turning off log shipping

On 09/07/2017 05:07 PM, Michael Paquier wrote: On Thu, Sep 7, 2017 at 11:08 PM, Tom Lane wrote: Manual cleanup shouldn't be very hard, fortunately. Run pg_controldata to see where the last checkpoint is, and delete WAL files whose names indicate they are before that (but

Re: [GENERAL] WAL & ready files retained after turning off log shipping

On 09/07/2017 09:08 AM, Tom Lane wrote: Ron Johnson <ron.l.john...@cox.net> writes: After disabling log shipping via setting "archive_mode = off", and then running, "pg_ctl reload", old WAL files and their associated .ready files aren't being deleted. Hmm. I migh

[GENERAL] WAL & ready files retained after turning off log shipping

Hi, v8.4 (and there's nothing I can do about it). After disabling log shipping via setting "archive_mode = off", and then running, "pg_ctl reload", old WAL files and their associated .ready files aren't being deleted. Is there any document you can point me to as to why this is happening,

Re: [GENERAL] Veritas cluster management

On 08/30/2017 08:48 AM, Scott Mead wrote: On Wed, Aug 30, 2017 at 9:43 AM, Ron Johnson <ron.l.john...@cox.net <mailto:ron.l.john...@cox.net>> wrote: Hi, For any of you with those failover clusters, do you know if "pg_ctl reload" works (for compatib

[GENERAL] Veritas cluster management

Hi, For any of you with those failover clusters, do you know if "pg_ctl reload" works (for compatible config file changes), or must we bounce the database using "hares -offline" then "hares -online"? Thanks -- World Peace Through Nuclear Pacification -- Sent via pgsql-general mailing

Re: [GENERAL] Logging the fact that a log was shipped

On 08/28/2017 08:22 AM, Stephen Frost wrote: * Christoph Moench-Tegeder (c...@burggraben.net) wrote: ## Ron Johnson (ron.l.john...@cox.net): How is this done in v8.4? (I tried adding "date; rsync ..." but pg didn't like that *at all*.) There's a DEBUG1-level log message on

Re: [GENERAL] Logging the fact that a log was shipped

On 08/28/2017 06:06 AM, Christoph Moench-Tegeder wrote: ## Ron Johnson (ron.l.john...@cox.net): How is this done in v8.4? (I tried adding "date; rsync ..." but pg didn't like that *at all*.) There's a DEBUG1-level log message on successful archive_command completion - that woul

[GENERAL] Logging the fact that a log was shipped

Hi, How is this done in v8.4? (I tried adding "date; rsync ..." but pg didn't like that *at all*.) Thanks -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Log shipping in v8.4.7

On 08/27/2017 02:23 PM, Christoph Moench-Tegeder wrote: ## Ron Johnson (ron.l.john...@cox.net): Everything I've read says that you should use "rsync -a". Is there any reason why we can't/shouldn't use "rsync -az" so as to reduce transfer time? On today's LANs,

[GENERAL] Log shipping in v8.4.7

Hi, (Yes, its old. Nothing I can do about that.) Everything I've read says that you should use "rsync -a". Is there any reason why we can't/shouldn't use "rsync -az" so as to reduce transfer time? Also, does that change require a full restart (difficult with production systems)? Thanks

Re: [GENERAL] PG and database encryption

On 08/22/2017 02:55 PM, Joshua D. Drake wrote: On 08/22/2017 12:48 PM, rakeshkumar464 wrote: We have a requirement to encrypt the entire database. What is the best tool to accomplish this. Our primary goal is that it should be transparent to the application, with no change in the application,

Re: [GENERAL] Fwd: 2 process postgres -D for one instance

On 08/11/2017 02:35 PM, Peter Eisentraut wrote: On 8/11/17 10:15, Murtuza Zabuawala wrote: some time whe have 2 process postgres for 1 instance like this exppgs*17769* 1 0 01:06 ?00:01:04 /usr/pgsql-9.3/bin/postgres -D /bases/postgresql/scl/data -i -p 5450 -h

Re: [GENERAL] CPU

quietness. - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHVNgCS9HxQb37XmcRArgLAKCqTxy49KKaRy3P2UUqEyy6LJJKHACg0RDm 8TeEugJQYEGwyJ3nZBUWc9I= =LBD2 -END PGP SIGNATURE

Re: [GENERAL] postgresql in ramdisk

should see my Russian!!! - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHUvf5S9HxQb37XmcRApraAKDlKLorRwSSuqVe66cUBbmPdaJXrQCgsLa0 589HllNDuKk8ImByzPAtJBE= =ZH4M -END PGP SIGNATURE

Re: [GENERAL] One or more tables?

( id, datetime, some_data) This should help you to decide how to design your tables. 3NF is as far as you really need to go. http://en.wikipedia.org/wiki/Data_normalization http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=88 - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my

Re: [GENERAL] One or more tables?

whenever you add a new user. Cluster by *range* of user ids, and preallocate some number of tablespaces. - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHU0tsS9HxQb37XmcRAhPoAJsESJL/Zs

Re: [GENERAL] Stored procedure issue

.) - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHUh9nS9HxQb37XmcRAjPTAJ4jRUZUaF+j2KAB3+lBY6A3ROfynACfawWT 0QN026Ncl/Iag2M6E1kfjUg= =RlXy -END PGP SIGNATURE

Re: [GENERAL] Linux v.s. Mac OS-X Performance

more expensive than on Unix (given that win32 is optimized towards context switching between threads). NTFS Isn't that why Apache2 has separate thread mode and 1.x-style pre-forked mode? isn't optimized for having 100+ processes reading and writing to the same file. Probably others.. - -- Ron

Re: [GENERAL] Select all fields except one

you want to do with just SQL. - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHTaTaS9HxQb37XmcRAiaWAJ9/BiarNsC9UUNyreg8LiIq9+mUKwCeNS/L 1y4DkS4vJbJd15ZbPuwalac= =QZG7 -END PGP SIGNATURE

Re: [GENERAL] PostgresSQL vs. Informix

different disk layouts than the original database. - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHTgd3S9HxQb37XmcRAs5kAKCSuOLOguqhpf/DT0OxbA6ew33CWQCfaVf1 KBzM2RxA91WQEa7MM02SKZg= =lvNg

Re: [GENERAL] Linux v.s. Mac OS-X Performance

Turns out that there was/is a bug in glibc's malloc(). Don't know if it's been fixed yet. - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux

Re: [GENERAL] Linux v.s. Mac OS-X Performance

programmers still haven't quite figured out what it's good for. Even AfterStep is written is plain C... - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHTMqjS9HxQb37XmcRAmS

Re: [GENERAL] Linux v.s. Mac OS-X Performance

. Wasn't there a time (2 years ago?) when PG ran pretty dog-like on SPARC? - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHTMzQS9HxQb37XmcRAo91AJ0d1l1LW0REaUEyVwrkhAF7u6+EYgCaA1aG

Re: [GENERAL] Primary Key

in.) - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHSzxlS9HxQb37XmcRAh0QAKCLp5aNkoPPs8P5oXQCJ0HI28MNuACeKtFH eECn8XRwrjOqonUuDr8DDH8= =cYiG -END PGP SIGNATURE

Re: [GENERAL] Disk arrangement in a cheap server

On Nov 24, 2007 12:06 PM, Steve Atkins [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: On Nov 24, 2007, at 8:17 AM, Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/24/07 09:12, Scott Marlowe wrote: On Nov 24, 2007 5:09 AM

Re: [GENERAL] Disk arrangement in a cheap server

drives for RAID 1. You don't mention what OS you'll use, but if you really need cheap then XP Linux do sw RAID, and FreeBSD probably does too. - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux

Re: [GENERAL] Primary Key

. ie use car number plates rather than some serial int. I wouldn't trust plate number to be unique over time, since the format ABC 123 only has a capacity of 17,576,000 vehicles. - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -BEGIN PGP SIGNATURE

Re: [GENERAL] Primary Key

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/17/07 01:21, Gregory Stark wrote: Ron Johnson [EMAIL PROTECTED] writes: On 11/16/07 12:50, João Paulo Zavanela wrote: Hello, How many fields is recomended to create a primary key? I'm thinking to create one with 6 fields, is much

Re: [GENERAL] Primary Key

column. Fie on you evil synthetic key lovers. Long live the Natural Key! - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHPel7S9HxQb37XmcRAmPZAJ9mml45XtPRSCrAiQ7K+LCwWf5J5QCgvaSp

Re: [GENERAL] Primary Key

or 6 or 24. Doesn't matter. - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHPej/S9HxQb37XmcRAo5mAJoDwp1E+aL2M/oTWhOsR5XYJi0AhgCgvUgU /ZB7nP+K6j0WW8vNn5Q8tFI= =s+zS -END PGP SIGNATURE

Re: [GENERAL] Primary Key

that they can't divine all situations. So, you add a new column to the PK and keep on going. But still, there *are* some circumstances where natural PKs just don't work. After all, SSNs and credit card numbers are synthetic (just not generated sequential by the RDBMS). - -- Ron Johnson, Jr

Re: [GENERAL] Syntax error in a large COPY

adhere to the law of the land, or when in Rome, ... practice instead of kicking off fuss. And with my mail client top-posting has no place. Let's just stick to good old standards. SARCASM What ever happened to I gotta do what's right for me! and I'm OK, you're OK? /SARCASM - -- Ron Johnson, Jr

Re: DB on a ramdisk (was Re: [GENERAL] Temporary, In-memory Postgres DB?)

PM To: Ron Johnson Cc: pgsql-general@postgresql.org Subject: Re: DB on a ramdisk (was Re: [GENERAL] Temporary, In-memory Postgres DB?) Ron Johnson [EMAIL PROTECTED] writes: On 11/07/07 09:58, Tom Lane wrote: Or put it on a ramdisk filesystem. But doesn't that just add more overhead

DB on a ramdisk (was Re: [GENERAL] Temporary, In-memory Postgres DB?)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/07/07 09:58, Tom Lane wrote: Ron Johnson [EMAIL PROTECTED] writes: On 11/07/07 09:03, Gauthier, Dave wrote: Is there such a thing as a temporary, probably in-memory, version of a Postgres DB? If you have enough RAM, and your database

Re: [GENERAL] Temporary, In-memory Postgres DB?

to have stored functions and other real database features that it just doesn't have. If you have enough RAM, and your database is small enough, the OS will eventually cache the whole thing. I know that's not exactly what you're talking about, but I think it's as close as you'll get. - -- Ron

Re: [GENERAL] How to create primary key

/docs/8.2/static/sql-altertable.html - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHMFr/S9HxQb37XmcRAuqfAKCzmYeBU4dVXorvQxBUYIoQuw9YcgCeOve1

Re: [GENERAL] How to temporarily disable a table's FK constraints?

other way for non-root users? The whole idea of enforcing Relational Integrity in the database engine is to *not* allow regular users to bypass data integrity checks. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good

Re: [GENERAL] How to ALTER a TABLE to change the primary key?

/interactive/sql-altertable.html - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHIbwhS9HxQb37XmcRAjg6AJ4sPW7wPH599JPVdmZ5s25b5yHnHQCeJtsr 0TRv9XcYy2

Re: [GENERAL] Using Postgres as a embedded / SQL Lite database on Windows

- which I can see as being worst than supporting Postgres Installs. I think that you're just going to have to create a pilot project to see how it fits your individual needs. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away

Re: [GENERAL] SQL spec/implementation question: UPDATE

and loose with SQL. IOW, the RDBMS shouldn't try to out-think me even if I seem seem to be doing something odd. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU

Re: [GENERAL] Abbreviation list

is generic enough that if PG is ever ported to the IBM 1400 that you won't have to come up with a new acronym: DLOB (Decimal Large OBject). - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE

Re: [GENERAL] Temp Table

, five, six, seven from loop_import order by loop_id ; fetch next From loop_set; Wouldn't it be simpler to do: INSERT INTO some_temp SELECT field list FROM some_table; - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes

Re: [GENERAL] Inconsistence in transaction isolation docs

the same query will return the same result set over and over again regardless of the updates to the base tables. And is why READ COMMITTED makes your RDBMS fail part 3 (Isolation) of the ACID test. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish

Re: [GENERAL] improvement proposition

queries it is next to impossible to tell where in app code the problem lies. it would be very useful to get something like previous query. Transaction analysis is the way to go here. It requires a serious code review, though. is adding something like this possible? - -- Ron Johnson, Jr. Jefferson

Re: [GENERAL] good sql tutorial

reports with a report writer like openrpt. Thanks for any suggestions. My suggestion: tell him that the SQL interface is broken. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version

Re: [GENERAL] good sql tutorial

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/04/07 11:06, Geoffrey wrote: Ron Johnson wrote: On 10/04/07 10:28, Geoffrey wrote: Anyone have a recommendation for a good sql tutorial? Looking for a book, but online would be useful as well. This is for a financial user who will need

Re: [GENERAL] Feature Request - Defining default table space for Indexes in Conf file

is it to specify tablespace when creating an index? - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHAnExS9HxQb37XmcRAiceAJ9vUNKVa8voo2gISHhzDgKY4OOkuQCgxuxG

Re: [GENERAL] pg_dump

. - with, as well as without, the data. Can this task be accomplished by employing pg_dump in SQL? If you dump with inserts, data only, then yes but it will be slow as snot to import. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes

Re: [GENERAL] Please change default characterset for database cluster

On 09/30/07 10:31, brian wrote: [snip] The default for MySQL is latin1 with swedish sorting. Yorn desh born, der ritt de gitt der gue Orn desh, dee born desh, de umn børk! børk! børk! -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he

Re: [GENERAL] Please change default characterset for database cluster

is such a rabid UTF8 fan, one wonders why his default locale setting isn't using UTF8 ... He uses Windows? - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU

Re: [GENERAL] Is this good spec for a PostgreSQL server?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/23/07 22:40, Ow Mun Heng wrote: On Thu, 2007-09-20 at 07:55 -0500, Ron Johnson wrote: On 09/20/07 05:43, Ow Mun Heng wrote: hehe.. I'll end up running it on a low-end desktop w/ 1GB ram and a celeron 2G processor w/ ~30GB data/month. I

Re: [GENERAL] Is this good spec for a PostgreSQL server?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/20/07 05:43, Ow Mun Heng wrote: On Wed, 2007-09-19 at 08:40 -0500, Ron Johnson wrote: Yes, I think that it's a bit excessive but the company can afford it so why not... :) Lucky SOB. I can't get my company to spring for a dual-core 2GB

Re: [GENERAL] Calculate Weighted Aggregation between Two Tables

outer-join NS to C to indicate any west African countries with missing statistics. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux

Re: [GENERAL] Is this good spec for a PostgreSQL server?

something that can run java fast as well as postgresql... 12-14 users on a Quad-core system with 4GB RAM? Am I so old that (even accepting Tomcat and Java) that seems excessive? - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away

Re: [GENERAL] Is this good spec for a PostgreSQL server?

yes. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFG8Rn3S9HxQb37XmcRAmEXAKDuh3tm+8am5Baopiwzinxh009xdgCdGgxS 5RhuTNIo88h227syqIIzfdA= =/YEE

Re: [GENERAL] Is this good spec for a PostgreSQL server?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/19/07 08:32, Bjørn T Johansen wrote: On Wed, 19 Sep 2007 07:59:36 -0500 Ron Johnson [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/19/07 07:33, Bjørn T Johansen wrote: Well, it isn't really the largest

Re: [GENERAL] Recall: August Monthly techdata split fi

. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFG78l2S9HxQb37XmcRAjmlAJ9pHW2sDN/c2y6Rng+mzv3te+h2LgCdFZqw QYs2/bEoaWFlMW0+priEzTs= =i/MW

Re: [GENERAL] Q:Aggregrating Weekly Production Data. How do you do it?

/stdev of the weekly sample size based on different products/software mix etc. and still be able to answer correctly, what's the average of data_1 over the pass 2 months? That's the purpose of data warehouses and ETL, isn't it? - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish

Re: [GENERAL] Locking entire database

value NOT IN TABLE; If i have 2 processes running the same 100s of these at the same time i end up with duplicates. Even with isolation set to serializable any ideas? Unique index? - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes

Re: [GENERAL] strange TIME behaviour

-- 60030.824587 (1 row) Isn't current_time already a time? Why is the cast necessary? - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux

Re: [GENERAL] Locking entire database

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/15/07 19:59, Panagiwths Pediadiths wrote: On Sat, 15 Sep 2007, Ron Johnson wrote: On 09/15/07 03:28, Panagiwths Pediadiths wrote: Thats the fun part, I actually need to allow duplicates in specific cases but not in this one :) Same

Re: [GENERAL] Tablespaces on tertiary media

necessary in 2007? A couple of MSA-1000s stuffed with 1TB disks would hold an l-o-t *lot* of historical data. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU

Re: [GENERAL] Database/Table Design for Global Country Statistics

2 | 1970| 2 . Would that be considered as good table design then? What Richard says, plus: 1. The PK of New_Design should be country_id/year. 2. You also should not store the records where value is NULL. A left outer join would handle that. - -- Ron Johnson, Jr

Re: [GENERAL] Hardware recommendation: which is best

proposed? Opteron is the standard answer. What is your backup/recovery strategy? - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux

Re: [GENERAL] Hardware recommendation: which is best

need to insert, and how evenly spread across the 24 hour day do the inserts occur? - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux

Re: [GENERAL] Hardware recommendation: which is best

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/11/07 12:02, Phoenix Kiula wrote: On 12/09/2007, Ron Johnson [EMAIL PROTECTED] wrote: How (on average) large are the records you need to insert, and how evenly spread across the 24 hour day do the inserts occur? There will be around

Re: [GENERAL] arrays of foreign keys

with arrays of foreign keys, and if so, how does one do that? Thanks for any help. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux

Re: [GENERAL] Time Zone design issues

. There are system functions to inquire how you've set it. Browsers already report back a mountain of client data to the web server. I'd be stunned if FF, IE, Opera, Konq, etc don't already expose TZ, too. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him

Re: [GENERAL] Time Zone design issues

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/10/07 15:21, Alvaro Herrera wrote: [snip] I wouldn't trust the browser's TZ, and you would need a way to override it. Why? - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes

Re: [GENERAL] Time Zone design issues

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/10/07 19:50, Tom Lane wrote: Ron Johnson [EMAIL PROTECTED] writes: On 09/10/07 15:21, Alvaro Herrera wrote: I wouldn't trust the browser's TZ, and you would need a way to override it. Why? The browser may not know the setting, or may

Re: [GENERAL] Time Zone design issues

, and there have been no noticeable ill effects, since apps all know to adjust for TZ. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux

Re: [GENERAL] Scalability Design Questions

perfectly for this query, and then runs the query against this separate database. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux

Re: [GENERAL] Column as arrays.. more efficient than columns?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/07/07 02:49, Ow Mun Heng wrote: On Fri, 2007-09-07 at 00:18 -0500, Ron Johnson wrote: On 09/06/07 21:26, Ow Mun Heng wrote: I've not arrived at any conclusion but merely exploring my options on which way would be the best to thread. I'm

Re: [GENERAL] Column as arrays.. more efficient than columns?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/07/07 07:49, Merlin Moncure wrote: On 9/7/07, Ron Johnson [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/06/07 20:53, Merlin Moncure wrote: [snip] arrays are interesting and have some useful problems

Re: [GENERAL] an other provokative question??

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/07/07 01:37, Greg Smith wrote: On Fri, 7 Sep 2007, Ron Johnson wrote: Definitely a niche product. Stonebraker's commentary was unfortunately spun by the ComputerWorld columnist. Tech journalist morphing reality to make a provocative

Re: [GENERAL] Column as arrays.. more efficient than columns?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/07/07 09:00, Ow Mun Heng wrote: Datahouse or data warehouse? OLTP data warehouse. But OLTP DW are diametrically opposed in how you design, structure, load and use them. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he

Re: [GENERAL] Need suggestion on how best to update 3 million rows

* tuples that have the extra space problem? - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux

  1   2   3   4   5   6   7   >