for nearly an hour I aborted the query, and repeated it
Do you have an index on x and y? Also, does this work better?
CREATE TEMP TABLE huge_table AS SELECT x, y FROM ... GROUP BY x, y;
What does ANALYZE EXPLAIN have to say?
--
D'Arcy J.M. Cain | Democracy is three wolves
http://www
On Thu, 1 May 2008 02:55:10 -0400 (EDT)
Greg Smith <[EMAIL PROTECTED]> wrote:
> On Thu, 1 May 2008, D'Arcy J.M. Cain wrote:
>
> > Whenever I see one of those I simply blackhole the server sending them.
>
> Ah, the ever popular vigilante spam method. What if the m
enever I see one of those I simply
blackhole the server sending them.
People, please, I know the spam you get isn't your fault but it isn't my
fault either. You clean up your mailbox and I'll clean up mine.
--
D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is thre
even do stuff like track how many
of each type of something you have. That's something you can't do if
your database engine has done a generic speedup for you. You would
still have to create your own table for something like that and then
you get the hit twice.
--
D'Arcy J.M. Cain
ot sure what your point is here. Sure, you need the netmask but not
of every IP address you send to, only for the IP/network that you are
on. That's a grand total of one netmask per interface that you need to
know. And you don't store it in your database.
--
D'Arcy J.M. Cain <[EM
rhead on a 16-byte address is not "ridiculously
> bloated", especially if you want a netmask with it.
Besides, there are many cases where you want to track both ipv4 and
ipv6 for the same purpose and requiring two different fields would be
less than ideal.
--
D'Arcy J.M. Cain <[EMAIL
my http authentication is not
> impacted too significantly.
How often does the user information change? Can you simply create
standard Apache password files from cron during non-busy hours?
Sometimes the lower tech solution works best.
--
D'Arcy J.M. Cain <[EMAIL PROTECTED]>
;VACUUM FULL" returns space to the system. "VACUUM" only
frees the space for use by the database. In most cases a simple VACUUM
is all you need since you are going to just be asking for the space
back anyway eventually as your database grows.
--
D'Arcy J.M. Cain <[EMAIL
ke a pitch for a JavaScript-free tool. Just
collect all the pertinent information, work it out and display the
results in a second page. Some people just don't like JavaScript and
turn it off even if we can run it in our browser.
--
D'Arcy J.M. Cain <[EMAIL PROTECTED]>
'r'
> AND relnamespace = n.oid
> AND nspname = 'novac'
> ORDER BY 1;
I assume you meant "AND nspname != 'novac'"
--
D'Arcy J.M. Cain | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting o
essages
to the list.
By the way, mailman has a nice feature that sends messages that look
like admin requests (such as unsubscribe) to the admin. That cuts down
on the noise quite a bit.
--
D'Arcy J.M. Cain | Democracy is three wolves
http://www.druid.net/darcy/|
gh of a test. You could just be
seeing the result of your IDE drive lying to you about actually writing
your data. There may be other considerations but I would start with
checking with 10,000 or 100,000 transactions to overcome the driver
buffering.
--
D'Arcy J.M. Cain | Democracy is
ave it attached to a NetApp that ensures data writes
> to via the NVRAM can I safely turn fsync off to gain additional
> performance?
I wouldn't. Remember, you still have to get the data to the NetApp.
You don't want things sitting in the computer's buffers when it&#
ow dead and adds one at the end. There may be some
optimization if the engine does both in one operation.
--
D'Arcy J.M. Cain | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what
servers running
NetBSD with a home grown multi-master replication system. Need more
power? Just add more servers.
--
D'Arcy J.M. Cain | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP) | what&#x
which has been 64 bit clean since
1995 and has had the Opteron port integrated in its main tree (not as
patches to or a separate tree) since April 2003.
--
D'Arcy J.M. Cain <[EMAIL PROTECTED]>
http://www.NetBSD.org/
---(end of broadcast)---
at least one
benchmark.
http://www.feyrer.de/NetBSD/gmcgarry/
The benchmarks were run on a single processor but you can always run the
benchmark on whatever hardware you select - assuming that it runs both.
Isn't there also a PostgreSQL specific benchmark available?
--
D'Ar
person driving from Toronto and another coming from California (!).
Seconded. It was definitely worth the drive from Toronto.
--
D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 12
Q&A session):
Is there anyone else from the Toronto area going down that would like to
share the driving? I am planning to drive down Friday morning and drive
back Sunday. I'm not looking for expense sharing. I just don't want to
drive for eight hours straight.
--
D&
base to be opened in
read only mode without touching anything in the directory.
--
D'Arcy J.M. Cain <[EMAIL PROTECTED]|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/| and a sheep voting on
+1 416 425 1212 (DoD#0082)
On January 6, 2004 07:20 am, Shridhar Daithankar wrote:
> On Tuesday 06 January 2004 17:48, D'Arcy J.M. Cain wrote:
> > On January 6, 2004 01:42 am, Shridhar Daithankar wrote:
> > cert=# select relpages,reltuples::bigint from pg_class where relname=
> > 'certific
-
399070 | 24858736
(1 row)
But:
cert=# select count(*) from certificate;
[*Crunch* *Crunch* *Crunch*]
count
--
19684668
(1 row)
Am I missing something? Max certificate_id is 20569544 btw.
--
D'Arcy J.M. Cain <[EMAIL PROTECTED]|vex}.net> | Democracy is th
ink of it as an order or header table with a
balance, that has over 10 million records. Sometimes we have 200,000
transactions a day where we have to check the balance. We eventually moved
every field that could possibly be updated on a regular basis out to separate
tables. The improvement was d
23 matches
Mail list logo
