Hasnul Fadhly bin Hasan <[EMAIL PROTECTED]> writes:
> Just wondering, i ran vacuumdb but didn't get the information that you
> get about the free space even when i set the verbose option. How did
> you get that?
PG version? IIRC 7.4 was the first to include that info in the VACUUM
VERBOSE outp
"Rosny" <[EMAIL PROTECTED]> writes:
> B. For each department create tablespace. (Which means, if there
> are 7000 departments, there will be 7000 tablespace each contains
> 20 tables).
If your system has seven thousand separate logical filesystems attached
to it, there might be some value in hav
In the last exciting episode, [EMAIL PROTECTED] wrote:
> Hello everyone!
>
> Since our current Postgres server, a quad Xeon system, finally can't
> keep up with our load anymore we're ready to take the next step.
>
> So the question is: Has anyone experiences with running Postgres on
> systems with
The perhaps odd thing is that just about any alternative to quad-Xeon
is likely to be _way_ better. There are some context switching
problems that lead to it being remarkably poorer than you'd expect.
Throw in less-than ideal performance of the PAE memory addressing
system and it seems oddly cripp
On Dec 6, 2004, at 5:18 PM, [EMAIL PROTECTED] wrote:
Hello everyone!
Since our current Postgres server, a quad Xeon system, finally can't
keep up with our
load anymore we're ready to take the next step.
I'm assuming you've already done as much query tweaking as possible.
and are you sure you are
Hi Bryan,
Just wondering, i ran vacuumdb but didn't get the information that you
get about the free space even when i set the verbose option. How did
you get that?
Thanks,
Hasnul
Bryan wrote:
Postgresql is the backbone of our spam filtering system. Currently the
performance is OK. Wanted to kn
Hi,
This kind of long email.
After searching the mailing list, have not found good answer
for TableSpace. So, I try to post this question.
My question
Question :
1 Which option from below scenario will be good in term of performance and
future scalability?
2. Is it Option B1 below the righ
Hello everyone!
Since our current Postgres server, a quad Xeon system, finally can't keep up
with our
load anymore we're ready to take the next step.
So the question is: Has anyone experiences with running Postgres on systems
with
more than 4 processors in a production environment? Which syst
Postgresql is the backbone of our spam filtering system. Currently the
performance is OK. Wanted to know if someone could give this config a
quick run down and see if there is anything we can adjust here to smooth
out the performance. The IO Wait Times are outrageous, at times the load
will spi
Additional update:
After spending time in searching more option.
Both Postgresql and MySQL Claims
1. Postgresql:
http://www.postgresql.org/users-lounge/limitations.html
2.MySQL
(Drawback creating large numbers of tables)
http://forums.devshed.com/t27778/s.html
This might sound like crazy ideas. I
Pierre-Frédéric Caillaud wrote:
Your suffering comes from the "where ba.bankaccountID =
u.bankaccountID" in the subselect. It means postgres has to run the
subselect once for each row in Users. You want the subselect to run
only once, and return one (or more?) bankaccountid's, then fetch
Your suffering comes from the "where ba.bankaccountID = u.bankaccountID"
in the subselect. It means postgres has to run the subselect once for each
row in Users. You want the subselect to run only once, and return one (or
more?) bankaccountid's, then fetch the users from Users.
Just
On Fri, Dec 03, 2004 at 07:19:37AM -0700, Cott Lang wrote:
> Consider Sun's new line of Opterons. They've been around for a couple of
I wouldn't buy a ray of sunshine from Sun in the middle of January at
the north pole, given the customer experience I had with them. They
had consistent failures i
Pierre-Frédéric Caillaud wrote:
Just One, user can i have only one bankaccount.
Ah well, in that case :
This is your query :
select userID, fname, lname, email, phone, dateEntered, dateCanceled,
dateSuspended, billAmount, billDate, dateBilled, datePaid, '?' as
searches
from Users u
where
Just One, user can i have only one bankaccount.
Ah well, in that case :
This is your query :
select userID, fname, lname, email, phone, dateEntered, dateCanceled,
dateSuspended, billAmount, billDate, dateBilled, datePaid, '?' as searches
from Users u
where 1=1 AND exists (select userID
Folks,
I'm wondering if people have had success with 7.4 and 8.0 using specific
compile optimizations not provided by the default PG install.Since -O2
and others have been built into config, I've not been doing much myself.
What are other people's experiences in this area? Do you have
Pierre-Frédéric Caillaud wrote:
Just wanted to know the selectivity of the accountnumber and
routingNumber columns.
I shoulda written :
How many rows do the following queries return :
One or few at most, or a lot ?
Just One, user can i have only one bankaccount.
select userI
Just wanted to know the selectivity of the accountnumber and
routingNumber columns.
I shoulda written :
How many rows do the following queries return :
One or few at most, or a lot ?
select userID
from bankaccount
WHERE accountnumber = '12345678'
select userID
Bryan <[EMAIL PROTECTED]> writes:
> vacuum_mem = 320
Yikes. You do realize that's measured in kilobytes? Try backing it off
to something saner, like half a gig or less.
regards, tom lane
---(end of broadcast)---
TIP 3:
Pierre-Frédéric Caillaud wrote:
How many rows do the following queries return :
select userID
from bankaccount ba
where ba.bankaccountID = u.bankaccountID
and ba.accountnumber = '12345678'
select userID
from bankaccount ba
where ba.ba
How many rows do the following queries return :
select userID
from bankaccount ba
where ba.bankaccountID = u.bankaccountID
and ba.accountnumber = '12345678'
select userID
from bankaccount ba
where ba.bankaccountID = u.bankaccountID
Hi Everybody,
I have a performance problem with this query , it takes lot of time
on the production database. is there a way to improve it ? i do vacuumdb
on this database and do anlyze on the users table separately daily
select userID, fname, lname, email, phone, dateEntered, dateCanceled,
According to these lines you should set max_fsm_pages to at the very
least 5306160
You have a humongous amount of RAM, you could set it to 1000
INFO: free space map: 79 relations, 1948399 pages stored; 5306160 total
pages needed
DETAIL: Allocated FSM size: 500 relations + 200 page
Postgresql is the backbone of our spam filtering system. Currently the
performance is OK. Wanted to know if someone could give this config a
quick run down and see if there is anything we can adjust here to smooth
out the performance. The IO Wait Times are outrageous, at times the load
will spi
Hi all!
Has anyone done any performance benchmarking of postgresql 7.4 vs 8.0?
Are there any scenarios where 8.0 can be expected to be faster? I
would love to get my hands on any numbers that someone might have.
Also does anyone know how long it will take for a stable release of
8.0 to come? Given
25 matches
Mail list logo
