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
On 11/16/2017 03:13 PM, bricklen wrote:
On Thu, Nov 16, 2017 at 1:07 PM, Ron Johnson <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_restore of a custom dump,
w
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 d
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 sta
42, 1);
DELETE FROM a WHERE id=1;
ERROR: update or delete on table "a" violates foreign key constraint
"b_fkey" on table "b"
DETAIL: Key (id)=(1) is still referenced from table "b".
Yours,
Laurenz Albe
--
Ron Johnson, Jr.
Jeffe
DB or many.
Does PG set up buffers at the postmaster level or the database level?
If at the database level, then you'll be allocating memory to
databases that might not be in use at any one time, thus wasting it.
One database buffer pool would make more efficient use of RAM.
--
Ron Johnson,
TWEEN '2007-06-01' AND 2007-06-30'
AND PRICE = 112.0
ORDER BY PRICE DESC
LIMIT 1
UNION
SELECT *
FROM T_OPTION
WHERE TICKER = 'AAPL'
AND EXPIRE_DT BETWEEN '2007-06-01' AND 2007-06-30'
AND PRICE = 112.0
ORDER BY PRICE ASC
LIMIT 1
;
I have rudimentary p
On 05/30/07 01:38, Albe Laurenz wrote:
Ron Johnson wrote:
Does PG set up buffers at the postmaster level or the database level?
If at the database level, then you'll be allocating memory to
databases that might not be in use at any one time, thus wasting it.
One database buffer pool
ce
arguments against updating a primary key (as the changes need to
propagate), but that depends on the needs of a particular (benchmarked
and tested) application environment.
--
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
Hit him with a f
s as useless delay.
In the meantime, a sleep(1) or some such before trying to drop a
recently-used database ought to be a usable workaround.
The proprietary DB that I use at work implemented something similar
as a command-line qualifier, and I guarantee you that it's been
tremendously u
ssuming that all of these standards guarantee such
stability, and I wanted to disabuse folks of that.
It's very interesting and useful to know.
--
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!
-
ould it be to modify the process (the postmaster?)
that writes the xlogs(?) to tee them to a listening process across
the cloud on the DR machine, which then applies them to the DR database?
This then begs the question: are CREATE|ALTER TABLESPACE commands
stored in the xlogs?
--
Ron Johns
s the table once, building separate
sortwork files on-the-fly. Too bad child processes can't inherit
transaction state.
--
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!
-
On 06/01/07 16:25, Andrew Sullivan wrote:
On Fri, Jun 01, 2007 at 03:58:01PM -0500, Ron Johnson wrote:
What you need are disk blocks to be mirrored to a machine at the DR
site. Or "continuous PITR" to the DR machine.
I thought you could already do this? (I'm not, but I
all the indexes on a single table) command be easier to implement?
You can get the effect right now by using concurrent connections it
seems. Not very practical in a psql script, though...
--
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
H
ing pretty Slony specific, though, so if we're to
continue this thread, I suggest we do it on the Slony list.
--
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!
---(end of broadcast)---
On 06/01/07 18:35, Joshua D. Drake wrote:
Ron Johnson wrote:
On 06/01/07 17:31, Andrew Sullivan wrote:
On Sat, Jun 02, 2007 at 12:23:44AM +0200, Alexander Staubo wrote:
Could you not (I ask naively) detect the first DDL statement is
submitted in a transaction
Maybe.
on the master, then
On 06/01/07 19:17, Joshua D. Drake wrote:
Ron Johnson wrote:
On 06/01/07 18:35, Joshua D. Drake wrote:
Since DDL is infrequent, is that bottleneck an acceptable trade-off?
Define infrequent? I have customers that do it, everyday in prod.
They do it willingly and refuse to change that habit
ng (and/or expensive) to ensure uniqueness across
partitions.
Are partitioned databases the same as federated databases?
--
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!
---(end of
the insert of value 2. Value 1 remains in the
table,
-- because it is already committed.
Regards,
Dawid
--
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!
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
#x27;s another definition of transactional DDL, I'd like
to know what it is.
Michael Glaesemann
grzm seespotcode net
This is what happens in every RDBMS. Whats so special about postgres then?
But it's NOT what happens in every RDBMS. Oracle implicitly
executes a COMMIT after eve
ally* fast
database box. You might not need more than that.
But if you *do* need the continuous uptime that shared-disk
clustering and rolling in-place upgrades gives you, then Rdb/VMS
can't be beat. It'll *cost*, though.
--
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he
g.,
<http://www.postgresql.org/docs/8.1/interactive/ddl-schemas.html>
A (relational) database is a database, and an RDBMS is what
manipulates that (relational) database.
"The" schema "defines" the database. "A" schema defines a specific
logical sub-set of "the"
any insight you can shed into this matter.
What index(es) is/are on GAME and GAME_COUNTS?
What version of PG are you running?
Are you pushing the box too hard?
--
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!
--
mer
credit cards.
But yes, I've always worried about that.
One
way around that is to hash the value instead. Then to validate, at
runtime you hash the user-entered password using the same hash function,
and validate that it matches the stored hash. No one in your company
eve
On 06/05/07 08:59, Alvaro Herrera wrote:
Ron Johnson wrote:
On 06/04/07 17:54, Guy Rouillier wrote:
Many people consider two-way encryption to be insecure; two-way
encryption means you can decrypt a value if you know the key, and it is
insecure because you usually have to put the key into
in Oracle Database uses "consistent read", so the
query might miss uncommitted changes from other transactions.'
Isn't it *supposed* to mis UNcommitted changes from other transactions?
--
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
Hit him wit
t.
The DELETE should block, no?
--
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!
---(end of broadcast)---
TIP 4: Have you searched our list archives?
On 06/13/07 17:23, PFC wrote:
On Thu, 14 Jun 2007 00:09:20 +0200, Ron Johnson <[EMAIL PROTECTED]>
wrote:
On 06/13/07 16:59, PFC wrote:
Isn't it *supposed* to mis UNcommitted changes from other transactions?
Well, if the "uncommited change" is a DELETE of the
n't cause an inconsistent
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!
---(end of broadcast)---
TIP 4: Have you searched our list
does what you think it
should do.
I wouldn't call Python *strongly* typed, but I do know what you
mean. I think.
--
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!
---(end of
t's all done in software.
Hardware acceleration for quickly counting the number of
set/unset/matching bits?
x86 doesn't already do that?
--
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!
---
uses, it's got it's share of worms
and rootkits.
The following is a bit out of proportion, but you may get
the idea"
"If the majority of the population had cancer it would still be
an illness and not the norm."
--
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and h
a database that doesn't respect html and i'll show you one i
don't want :).
Respect html?
WTH does that mean?
--
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!
-
On 06/16/07 17:05, Alexander Staubo wrote:
On 6/16/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
> Hardware acceleration for quickly counting the number of
> set/unset/matching bits?
x86 doesn't already do that?
I don't think so. The fastest way, I believe, is to use pre
On 06/17/07 00:19, Greg Smith wrote:
On Sat, 16 Jun 2007, Ron Johnson wrote:
Anyway... databases are always(?) IO bound. I'd try to figure out how
to make a bigger hose (or more hoses) between the spindles and the mobo.
What I keep waiting for is the drives with flash memory built-
ll need
to engineer them properly. Why?
1) There's always a bottleneck.
2) There's always more data to "find" the bottleneck.
So, to answer the OP, my answer would be to 'get rid of
the spinning disk!' :-)
--
Ron Johnson, Jr.
Jefferson LA USA
G
s fast and winnows
down the result set. That's the theory, of course.
--
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!
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On 07/03/07 13:03, Merlin Moncure wrote:
On 7/2/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
On 06/18/07 08:05, Merlin Moncure wrote:
[snip]
>
> That being said, it's pretty clear to me we are in the last days of
> the disk drive.
Oh, puhleeze. Seagate, Hitachi, Fuji a
On 07/04/07 16:00, Andrej Ricnik-Bay wrote:
On 7/4/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
"Enterprise-level" tapes can sit in storage for 7-15 years and then
still be readable. Can a disk drive sit un-used for 7 years? Would
the motor freeze up? Will we still be able
On 07/08/07 22:07, lai yoke hman wrote:
Hello,
Is there any direct I/O instead of buffered I/O for postgresql?
Thank you.
Why do you want raw IO? Performance would tank.
--
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
what_.
There's no "shared temp table" support in Postgres.
Will GLOBAL TEMP tables be added any time soon?
I know the docs say that the standards implies needing modules, but
"shared definition" is really handy. We use regularly such GLOBAL
TEMP tables without modu
unt. But upgrades are still a chore.
--
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!
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
s it does some really OS-specific calls, *can* PostgreSQL know
how much *physical* RAM is in a box?
- --
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-
, and finish in short
> time to avoid long running transactions ? Cause I can't really think of
> one... other than our scheme with the delete with limit + trigger +
> private temp table thing.
Maybe add OIDs to the table, and delete based on the OID number?
- --
Ron Johnson, Jr.
Jefferson L
you're only reading
what you care about.
> Another problem is that presumably you're reindexing because the existing
> index *isn't* in such good shape. You may even be doing it because the
> existing index is corrupt.
That, of course, is an excellent point.
- --
Ron J
ves you lots of
Pardon me for being the contrarian, but why does a server need a
GUI? Isn't that just extra RAM & CPU overhead that could be more
profitably put to use powering the application?
> great things for free and already installed - granted most is publicly
> available, but
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/01/07 21:44, Andrej Ricnik-Bay wrote:
> On 8/2/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
>
>>> As an alternative viewpoint, I've been running the latest postgres on
>>> Mac OS X Server 10.4, and it's
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/01/07 21:58, Merlin Moncure wrote:
[snip]
>
> 3. binary packaging
> While I like the debian distros generally, I dislike the debian
> packaging of PostgreSQL. IMO, it's over engineered. If you plan to
How so?
- --
Ron Johns
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/01/07 22:05, Merlin Moncure wrote:
> On 8/2/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> On 08/01/07 10:37, Owen Hartnett wrote:
>>> At 4:52
(or schema) and restoring a backup file.
>
> Run pg_dump or pg_restore as a subprocess.
But that doesn't give you the capability of getting customized output.
- --
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 aw
usly doubt that's what he means.
"fsync=off" *is* faster than "fsync=on", but leaves your data at
risk in case of a hardware crash.
Turning it off during initial data load is quite common, though.
Just remember to turn it back on!!!
- --
Ron Johnson, Jr.
Jef
It is only logical that it will take 2x as long to insert 2x as much
data.
Maybe SQL Server is compressing out white space? Or (shudder)
heavily caching writes?
- --
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
ated locking engine
> (transactional ddl for example).
Although MVCC is not a /sine qua non/ of transactional ddl.
- --
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/15/07 00:05, Harpreet Dhaliwal wrote:
> And this feature i.e. transactional DDL is not there in other major
> RDBMS like sql server, oracle etc?
Define "major". Does it mean "popular" or "used on very large
t sure if the following helps, but I'm including the EXPLAIN on
> this table. Penny for your thoughts!
Whatever the issue, you can bet your car that it's not a bug in
PostgreSQL, but you who is misunderstanding how PG works.
Write a script that loops thru the records one by one, updatin
ng coffee.
>
> Moving all the application-bound inserts into stored procedures didn't
> achieve nearly the performance enhancement I'd assumed I'd get, which I
> figured was due to the overhead of the procs themselves.
Would that be because the original app was written in
keys are stored, etc.
Client-side encryption is important, because with server-side
encryption, you are sending the Valuable Data across the wire (or,
even worse!) wireless in cleartext form.
It's more likely that there's a packet sniffer on the network than
an Evil DBA snooping around.
- -
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/17/07 21:45, Steve Manes wrote:
> Ron Johnson wrote:
>>> Moving all the application-bound inserts into stored procedures didn't
>>> achieve nearly the performance enhancement I'd assumed I'd get, which I
&g
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/18/07 06:02, Phoenix Kiula wrote:
[snip]
>
> Thanks for this. I am logged in as root. Put it there and it works. I
Well, that's your first problem.
And second. And third.
- --
Ron Johnson, Jr.
Jefferson LA USA
Give a man a f
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/18/07 11:08, Joshua D. Drake wrote:
> Josh Tolley wrote:
>> On 8/18/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
>>> Interesting. Does PG have to initiate the Perl interpreter every
>>> time you call a Perl-writ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/18/07 21:10, Phoenix Kiula wrote:
> On 18/08/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
>>
>> On 08/18/07 06:02, Phoenix Kiula wrote:
>> [snip]
>>> Thanks for this. I am logged in as root. Put it there and it
*many*
times more reads than writes.
- --
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)
iD8DBQFGzMNDS9HxQb37XmcRAgMLAJsGvA43MKrfRKoyf0W0Nv5/VWu5gACdG8qh
edit card processors and some other companies
>> do it... it just costs a LOT to actually do it well.
>
> Isn't this sort of requirement the entire reason for 2-phase commit?
Entire reason? Not that I've heard.
- --
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and
(and not only the link?).
> Normally, that's solved with a quorum device. So that you have to have
> at least three servers - preferably in different locations.
- --
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
Hit
but this would be ineffecient & slow.
>
> Anyone have a suggestion to do this in an efficient manner?
>
> Thanks in advance
- --
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 SIGNED MESSAGE-
Hash: SHA1
On 08/25/07 22:21, Kevin Kempter wrote:
> On Saturday 25 August 2007 21:10:19 Ron Johnson wrote:
>> On 08/25/07 21:51, Kevin Kempter wrote:
>>> Hi List;
>>>
>>> I have a very large table (52million rows) - I'
serting records?
How fast are the disks?
SCSI or SATA/IDE?
How much RAM?
- --
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)
ise computationally-intensive operation that you're performing
on 20 million rows, you'll definitely see the difference.
- --
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-
Ver
#x27;s well explained in the documentation...
- --
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)
iD8DBQFG1XaWS9HxQb37XmcRAi5hAKDff5j5KnqWdGKxHjCJuTwXxfPwjACfZuko
1
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/29/07 09:34, Decibel! wrote:
> On Wed, Aug 29, 2007 at 08:37:26AM -0500, Ron Johnson wrote:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> On 08/29/07 07:27, cluster wrote:
>>> OK, thanks. But wh
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/29/07 10:40, Joshua D. Drake wrote:
> Ron Johnson wrote:
>> On 08/29/07 09:34, Decibel! wrote:
>>> On Wed, Aug 29, 2007 at 08:37:26AM -0500, Ron Johnson wrote:
>>>>
>>>> On 08/29/07 07:27, cluster
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/29/07 10:47, Tom Lane wrote:
> Ron Johnson <[EMAIL PROTECTED]> writes:
>> On 08/29/07 07:27, cluster wrote:
>>> Just make sure and read up about transaction isolation... in the default
>>> of READ COMMITTED mo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/29/07 11:20, Joshua D. Drake wrote:
> Ron Johnson wrote:
>> On 08/29/07 10:40, Joshua D. Drake wrote:
>>> Ron Johnson wrote:
>
>>>> Argh!!! The RDBMS that I typically use defaults to SERIALIZABLE.
>>>
ter table, plus a "sequence number".
If you want to do it your way, though, PostgreSQL supports array types.
- --
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:
/docs/8.2/interactive/index.html
http://www.postgresql.org/docs/8.2/interactive/sql-copy.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 (
ented
*large* toll systems in the US Northeast.
In addition to the account databases, you need a "reference"
database for tables that can't be partitioned by account, be able to
run queries across databases, and middleware that knows how to
direct transactions to the correct database
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/07 06:12, Andrus wrote:
> I'm looking for a report generator which renders reports in server and sends
> rendering result to client.
"Render" as in "run the report program on the host"?
- --
Ron Johnson, Jr.
nd still hasn't ended.
>
> I've killed it already and rolled back the changes.
>
> what's the easiest way to update these fields?
Is it only *some* tuples that have the "extra space" problem?
- --
Ron Johnson, Jr.
Jefferson LA USA
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/06/07 04:20, Ow Mun Heng wrote:
> On Thu, 2007-09-06 at 04:07 -0500, Ron Johnson wrote:
>
>> On 09/06/07 01:13, Ow Mun Heng wrote:
>
>>> update org_column set number = foo.number where foo.unique_id =
>>>
le
corruption and *poof*, you've lost a table. A strategically placed
corruption and you've lost your database.
But... that's why database vendors create backup/restore commands.
You *do* back up your database(s), right??
- --
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fi
and other issues that come
> up with de-normalization tactics.
ACK.
- --
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)
iD8DBQFG4N+/S9HxQb
now, there's 8 million rows of data in this one table, and growing
> at a rapid rate of ~2 million/week. I can significantly reduce this
> number down to 200K (i think by denormalising it) and shrink the table
> size.
Even presuming you only insert data SIX hours per day, that
-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 wa
-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]
>>
-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
ything to do with the concept of a relational
> database. It's an implementation detail --- maybe a pretty fundamental
> one, but in principle you could build a DB either way and no user could
> see a semantic difference.
- --
Ron Johnson, J
-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.
Jeffers
ce as you biggest mbox file. What a PITA.
mh and Maildir are, as has been partially mentioned, much more
efficient in that regard.
(Yes... mbox is an excellent transport format.)
- --
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 a
to a
*separate* database (so that backups & CREATE INDEX don't clash),
indexes them 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 a
internal clocks set to UTC for a decade
or more, 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!
-BEGI
really like to avoid doing that.
Why?
The (literally) cardinal rule of database normalization is
"eliminate repeating values".
> Is there a solution to this problem with arrays of foreign keys, and
> if so, how does one do that?
>
> Thanks for any help.
- --
Ro
pick one if you get it wrong. Then you can store that
> timezone in a user profile and set it everytime the user uses your web
> app.
In both Windows *and* Unix "you" set your TZ when you install the
system. There are system functions to inquire how you've set it.
Brows
-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
-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.
&
rmance
> across a single-CPU Quad Core Xeon with a dual CPU dual-core AMD
> Opteron? Or should the hard disk and RAM be the major considerations
> as usually proposed?
Opteron is the standard answer.
What is your backup/recovery strategy?
- --
Ron Johnson, Jr.
Jefferson LA USA
Give a
houghts based
> on above info.
How (on average) large are the records you 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 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?
quot;value is NULL". A
left outer join would handle that.
- --
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)
iD8DBQFG57E/S9HxQb37XmcRAsb/AJ97lFt25sLwIYhkhQ
vant 10 years ago, is it
really 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---
1 - 100 of 637 matches
Mail list logo
