can "lock down" those entities and/or verify traffic with them to
my heart's content, this seems to be the best way to avoid SQL code
injection, processes that bootstrap their privileges, etc, etc.
So how do I do this?
Ron
---(end of broadcast)---
Subject says it all. Doing a source compile under Debian or
Debian-like condition is not an option for the end user. They need
an apt-get (the ubuntu equivalent to rpm AFAICT) version.
Unfortunately, the latest I can find is 8.1.8
Where's 8.2.3?
Help?
Ron
--
e postmaster or send it a sighup to reread the configuration
settings. Check out the documentation at
http://www.postgresql.org/docs/7.3/static/client-authentication.html
Ron
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
e newbies. OTOH
I *can't* recommend the O'Reilly book because the index is very poor,
making it useless as reference material.
Ron
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send &
Peter Choe wrote:
i am trying to add a record of a name. the name has an apostrophe
(O'Neil).
i am doing this through a servlet and wrote the code to use
PreparedStatement.
when i do:
...
PrepareStatement pstmt = con.prepareStatement("INSERT INTO directory
(name, phone) VALUES (?,?)");
pstmt
=# INSERT INTO son VALUES (NULL);
> INSERT 183320 1
> Servus
> Manfred
Anyone know how I can get this to work? BTW I don't want to use 'ignore'
rules when someone attempts to delete the company as I want the
constraint message to be shown in the app's browser.
TIA
Ron
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
s there a way I can modify an existing database to get the same
end-result (eg it works when DB is set up, before it is populated with
data)?
Ron
Karen Grose wrote:
Ron,
I have done this by adding the attribute to the table with nulls allowed and adding a
constraint to the table for the fo
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!
-
Tom Lane wrote:
> Dave Page <[EMAIL PROTECTED]> writes:
>> I can't imagine Flickr or Slashdot ...
>
> I'm pretty sure I remember reading that Slashdot had to put enormous
> amounts of cacheing in front of their DB to keep it from falling over
> on a regular basis.
Yes, slashdot and flickr both us
Tom Lane wrote:
>
> Exactly. VACUUM sucks (ahem) in all ways but one: it pushes the
> maintenance costs associated with MVCC out of the foreground query code
> paths and into an asynchronous cleanup task. AFAIK we are the only DBMS
> that does it that way. Personally I believe it's a fundamenta
Alvaro Herrera wrote:
> André Volpato wrote:
>
>> The ammount of space saved seems pretty clear to me.
>
> Yeah, zero most of the time due to alignment.
So trading off more I/O for less CPU?
I wonder if for any I/O bound database servers
it might be worth packing tightly rather than
aligning in
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
Chris Browne wrote:
>
> The server does not need the overhead of having *any* of the "X
> desktop" things running; it doesn't even need an X server.
>
> You don't need X running on the server in order use those "enterprise
> management" tools; indeed, in a "lights out" environment, that server
>
(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
Tom Lane wrote:
> Oleg Bartunov <[EMAIL PROTECTED]> writes:
>> On Wed, 8 Aug 2007, cluster wrote:
>>> Does anyone know where I can request an OR-version of plainto_tsquery()?
>
>> plainto_tsquery expects plain text, use to_tsquery for boolean operators.
>
> Are either of these definitions really
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
sizes will be pretty
variable, from a few kilobytes to several hundred megabytes, so I need
something that will handle the various file sizes, hopefully transparently.
Thanks for any info,
Ron
-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
Moncure <[EMAIL PROTECTED]> wrote:
>
> On 8/15/07, Ron Olson <[EMAIL PROTECTED]> wrote:
> > Hi all-
> >
> > I am evaluating databases for use in a large project that will hold
> image
> > data as blobs. I know, everybody says to just store pointe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/17/07 23:16, Merlin Moncure wrote:
> On 8/18/07, Ron Olson <[EMAIL PROTECTED]> wrote:
>> The language is Java. I've made some tests and they work very well for 25meg
>> filesworks exactly the way it should, first ti
.
The explanation from Tom [2] was that there was some good
reason function lookups used SnapshotNow.
Ron
[1] http://archives.postgresql.org/pgsql-bugs/2005-04/msg00163.php
I have a long query something like
select slow_function(col) from large_table;
and half way through the query, in
-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
Decibel! wrote:
> On Aug 15, 2007, at 2:11 PM, Gregory Stark wrote:
>> "Decibel!" <[EMAIL PROTECTED]> writes:
>>> On Wed, Aug 15, 2007 at 01:26:02PM -0400, Steve Madsen wrote:
On Aug 15, 2007, at 11:52 AM, Decibel! wrote:
> I can't really think of a case where a seqscan wouldn't return all
-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
David Fetter wrote:
>> Dollar-quoting is a cute technical solution to that, but you can't
>> deny that it's simpler if you just restrict the function language to
>> be SQL-ish so that CREATE FUNCTION can parse it without any
>> interesting quoting rules. So sayeth Oracle and the SQL standards
>> c
-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
Scott Marlowe wrote:
> On 8/14/07, john_sm <[EMAIL PROTECTED]> wrote:
>> Hey guys, for an enterprise wide deployment, what will you suggest and why
>> among - Red Hat Linux, Suse Linux and Ubuntu Linux, also, do you think, we
>> can negotiate the support pricing down?
>
> It's more about your skil
*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:
Denis Gasparin wrote:
>> Yeah, you're wrong. The difference is that plain vacuum does not try
>> very hard to reduce the length of a table file --- it just frees up
>> space within the file for reuse. vacuum full will actually move things
>> from the end of the file to free space nearer the head
/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
1 - 100 of 990 matches
Mail list logo
