Thomas Burns <[EMAIL PROTECTED]> writes:
> I'm having a really stupid problem -- it seems to be impossible to
> download postgre. All of the US mirrors timeout. Is this normal?
Four out of the listed seven responded when I tried 'em just now ...
regards, tom lane
--
ftp3.us.postgresql.org is working for me.
On Tue, 11 May 2004, Thomas Burns wrote:
> Hi,
>
> I'm having a really stupid problem -- it seems to be impossible to
> download postgre. All of the US mirrors timeout. Is this normal?
> There are no apparent problems with my connection.
>
> Thomas E.
Thomas Burns <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm having a really stupid problem -- it seems to be impossible to
> download postgre.
Postgres, PostgreSQL, psql, pgsql, but not "postgre," please :).
>All of the US mirrors timeout. Is this normal?
> There are no appa
WARNING: Cache reference leak: cache pg_statistic (31), tuple 0 has count -1
redhat 9.0 -> Linux technet1.t-n-i.fst 2.4.20-27.9smp #1 SMP Thu Dec 11 13:15:04 EST
2003 i686 i686 i386 GNU/Linux
pstgres rpm
postgresql-server-7.3.4-3.rhl9
looks as though the table vacuum and my database wide vacuum w
Hi - I'm trying to get postgres 7.4.2 going on RedHat ES
The build went fine but I get the following when trying to start postgres
with this command:
[EMAIL PROTECTED] bin]$ ./pg_ctl -D /usr/local/pgsql/data/ -o "-i" start
LOG: could not create IPv6 socket: Address family not supported by prot
unsubscribe
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Tom Lane wrote:
(http://www3.sk.postgresql.org/docs/faqs/FAQ.html):
OIDs are stored as 4-byte integers, and will overflow at 4 billion. No
one has reported this ever happening, and we plan to have the limit
removed before anyone does.
That comment in the FAQ seems quite out-of-date.
Wha
Graham Clarke <[EMAIL PROTECTED]> writes:
> Hi - I'm trying to get postgres 7.4.2 going on RedHat ES
> The build went fine but I get the following when trying to start postgres
> with this command:
> LOG: disabling statistics collector for lack of working socket
It tries to bind a UDP port to t
Hi,
For some time I'm using a well-working (for me) Cygwin distribution -
v1.3.2, PostgreSql 7.3.2, CygIPC v.1.13.2, PsqlODBC v.07_02_0005. I
configured and started it fine in the past on WinNT, Win2K Pro/Server, WinXP
Home/Pro. Recently I tried to manage it under Win2003 Advanced Server (as
allwa
Hi,
I'm having a really stupid problem -- it seems to be impossible to
download postgre. All of the US mirrors timeout. Is this normal?
There are no apparent problems with my connection.
Thomas E. Burns
Founder, jGuru and knowspam.net
http://www.knowspam.net -- Enjoy Email with knowspam.net
http
Hi,
I am curious if there are any real life production quad processor setups
running postgresql out there. Since postgresql lacks a proper
replication/cluster solution, we have to buy a bigger machine.
Right now we are running on a dual 2.4 Xeon, 3 GB Ram and U160 SCSI
hardware-raid 10.
Has an
We use XEON Quads (PowerEdge 6650s) and they work nice, provided you configure the
postgres properly. Dell is the cheapest quad you can buy i think. You shouldn't be
paying 30K unless you are getting high CPU-cache on each processor and tons of memory.
I am actually curious, have you researched
On Tue, 11 May 2004, Bjoern Metzdorf wrote:
> Hi,
>
> I am curious if there are any real life production quad processor setups
> running postgresql out there. Since postgresql lacks a proper
> replication/cluster solution, we have to buy a bigger machine.
>
> Right now we are running on a dual
it's very good to understand specific choke points you're trying to
address by upgrading so you dont get disappointed. Are you truly CPU
constrained, or is it memory footprint or IO thruput that makes you
want to upgrade?
IMO The best way to begin understanding system choke points is vmstat
o
Anjan Dave wrote:
We use XEON Quads (PowerEdge 6650s) and they work nice,
> provided you configure the postgres properly.
> Dell is the cheapest quad you can buy i think.
> You shouldn't be paying 30K unless you are getting high CPU-cache
> on each processor and tons of memory.
good to hear, I trie
scott.marlowe wrote:
Well, from what I've read elsewhere on the internet, it would seem the
Opterons scale better to 4 CPUs than the basic Xeons do. Of course, the
exception to this is SGI's altix, which uses their own chipset and runs
the itanium with very good memory bandwidth.
This is basica
Did you mean to say the trigger-based clustering solution is loading the dual CPUs
60-70% right now?
Performance will not be linear with more processors, but it does help with more
processes. We haven't benchmarked it, but we haven't had any problems also so far in
terms of performance.
Pric
Paul Tuckfield wrote:
Would you mind forwarding the output of "vmstat 10 120" under peak load
period? (I'm asusming this is linux or unix variant) a brief
description of what is happening during the vmstat sample would help a
lot too.
see my other mail.
We are running Linux, Kernel 2.4. As soo
Anjan Dave wrote:
Did you mean to say the trigger-based clustering solution
> is loading the dual CPUs 60-70% right now?
No, this is without any triggers involved.
Performance will not be linear with more processors,
> but it does help with more processes.
> We haven't benchmarked it, but we have
scott.marlowe wrote:
Next drives I'll buy will certainly be 15k scsi drives.
Better to buy more 10k drives than fewer 15k drives. Other than slightly
faster select times, the 15ks aren't really any faster.
Good to know. I'll remember that.
In peak times we can get up to 700-800 connections at the
On Tue, 11 May 2004, Bjoern Metzdorf wrote:
> scott.marlowe wrote:
> > Sure, adaptec makes one, so does lsi megaraid. Dell resells both of
> > these, the PERC3DI and the PERC3DC are adaptec, then lsi in that order, I
> > believe. We run the lsi megaraid with 64 megs battery backed cache.
>
>
On Tue, 11 May 2004, Bjoern Metzdorf wrote:
> scott.marlowe wrote:
>
> > Well, from what I've read elsewhere on the internet, it would seem the
> > Opterons scale better to 4 CPUs than the basic Xeons do. Of course, the
> > exception to this is SGI's altix, which uses their own chipset and run
I'm confused why you say the system is 70% busy: the vmstat output
shows 70% *idle*.
The vmstat you sent shows good things and ambiguous things:
- si and so are zero, so your not paging/swapping. Thats always step
1. you're fine.
- bi and bo (physical IO) shows pretty high numbers for how many
On Tue, 11 May 2004, Bjoern Metzdorf wrote:
> I am curious if there are any real life production quad processor setups
> running postgresql out there. Since postgresql lacks a proper
> replication/cluster solution, we have to buy a bigger machine.
Du you run the latest version of PG? I've read
...and on Tue, May 11, 2004 at 03:02:24PM -0600, scott.marlowe used the keyboard:
>
> If you get the LSI megaraid, make sure you're running the latest megaraid
> 2 driver, not the older, slower 1.18 series. If you are running linux,
> look for the dkms packaged version. dkms, (Dynamic Kernel M
Hi,
How to use an internal variable?
Original question was how to set a variable in postgresql?
If I want to set a variable like start_date='2004-05-10';
How could I use it in my SQL statement?
E.g.
Db> set start_date '2004-05-10'
Db> select start_date as 'start date';
It's not executable!
Than
26 matches
Mail list logo
