Hello group,
Moreover a reindex (REINDEX name of your database while in pgsql) followed
by an ANALYZE will claim more space.
Regards
J6M
- Original Message -
From: Francisco Reyes [EMAIL PROTECTED]
To: choksi [EMAIL PROTECTED]
Cc: pgsql-performance@postgresql.org
Sent: Friday, June
Guillaume Smet [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Sabin,
On 6/14/07, Sabin Coanda [EMAIL PROTECTED] wrote:
I'd like to understand completely the report generated by VACUUM VERBOSE.
Please tell me where is it documented ?
You can take a look to what I did for
I am a Java Software architect, DBA, and project manager for the
University of Illinois, Department of Web Services. We use PostgreSQL
to serve about 2 million pages of dynamic content a month; everything
from calendars, surveys, forms, discussion boards, RSS feeds, etc. I am
really impressed
On 6/18/07, David Tokmatchi [EMAIL PROTECTED] wrote:
Scalability ? Performance? Benchmark ? Availability ? Architecture ?
Limitation : users, volumes ? Resouces needed ? Support ?
Aside from the Wikipedia database comparison, I'm not aware of any
direct PostgreSQL-to-Oracle comparison.
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
It's even harder, as Oracle disallows publishing benchmark figures in
their license. As a cynic, I might ask, what Oracle is fearing?
Andreas
Jonah H. Harris wrote:
On 6/18/07, David Tokmatchi [EMAIL PROTECTED] wrote:
Scalability ? Performance?
On 6/18/07, Andreas Kostyrka [EMAIL PROTECTED] wrote:
As a cynic, I might ask, what Oracle is fearing?
As a realist, I might ask, how many times do we have to answer this
type of anti-commercial-database flamewar-starting question?
--
Jonah H. Harris, Software Architect | phone: 732.331.1324
Jonah H. Harris wrote:
On 6/18/07, Andreas Kostyrka [EMAIL PROTECTED] wrote:
As a cynic, I might ask, what Oracle is fearing?
As a realist, I might ask, how many times do we have to answer this
type of anti-commercial-database flamewar-starting question?
Depends? How many times are you
2. Oracle, Microsoft, and IBM have a lot to fear in the sense of a
database like PostgreSQL. We can compete in 90-95% of cases where people
would traditionally purchase a proprietary system for many, many
thousands (if not hundreds of thousands) of dollars.
Oracle also fears benchmarks
Mario,
The JavaScript configuration tool I proposed would not be in the install
of PostgreSQL. It would be an HTML page. It would be part of the HTML
documentation or it could be a separate HTML page that would be linked
from the HTML documentation.
Thanks,
Lance Campbell
Project
PFC wrote:
2. Oracle, Microsoft, and IBM have a lot to fear in the sense of a
database like PostgreSQL. We can compete in 90-95% of cases where
people would traditionally purchase a proprietary system for many,
many thousands (if not hundreds of thousands) of dollars.
Oracle also fears
On 6/18/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
Depends? How many times are you going to antagonize the people that ask?
As many times as necessary. Funny how the anti-proprietary-database
arguments can continue forever and no one brings up the traditional
RTFM-like response of, hey,
Hi,
Joshua D. Drake wrote:
Slony-II
Seems brilliant, a solid theoretical foundation, at the forefront of
computer science. But can't find project status -- when will it be
available? Is it a pipe dream, or a nearly-ready reality?
Dead
Not quite... there's still Postgres-R, see
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jonah H. Harris wrote:
On 6/18/07, Andreas Kostyrka [EMAIL PROTECTED] wrote:
As a cynic, I might ask, what Oracle is fearing?
As a realist, I might ask, how many times do we have to answer this
type of anti-commercial-database
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
PFC wrote:
2. Oracle, Microsoft, and IBM have a lot to fear in the sense of a
database like PostgreSQL. We can compete in 90-95% of cases where
people would traditionally purchase a proprietary system for many,
many thousands (if not hundreds
Jonah H. Harris wrote:
On 6/18/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
Depends? How many times are you going to antagonize the people that ask?
As many times as necessary. Funny how the anti-proprietary-database
arguments can continue forever and no one brings up the traditional
On 6/18/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
Yeah funny how you didn't do that ;) (of course neither did I).
I agree, an oops on my part :)
It is amazing how completely misguided you are in this response. I
haven't said anything closed minded. I only responded to your rather
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jonah H. Harris wrote:
All of us have noticed the anti-MySQL bashing based on problems with
MySQL 3.23... Berkus and others (including yourself, if I am correct),
have corrected people on not making invalid comparisons against
ancient
On 6/18/07, Sabin Coanda [EMAIL PROTECTED] wrote:
Guillaume Smet [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Sabin,
On 6/14/07, Sabin Coanda [EMAIL PROTECTED] wrote:
I'd like to understand completely the report generated by VACUUM
VERBOSE.
Please tell me where is it
All,
On Mon, Jun 18, 2007 at 07:50:22PM +0200, Andreas Kostyrka wrote:
[something]
It would appear that this was the flame-fest that was predicted.
Particularly as this has been copied to five lists. If you all want
to have an argument about what Oracle should or should not do, could
you at
On 6/18/07, Campbell, Lance [EMAIL PROTECTED] wrote:
Mario,
The JavaScript configuration tool I proposed would not be in the install
of PostgreSQL. It would be an HTML page. It would be part of the HTML
documentation or it could be a separate HTML page that would be linked
from the HTML
On 6/18/07, Andrew Sullivan [EMAIL PROTECTED] wrote:
It would appear that this was the flame-fest that was predicted.
Particularly as this has been copied to five lists. If you all want
to have an argument about what Oracle should or should not do, could
you at least limit it to one list?
Markus Schiltknecht wrote:
Not quite... there's still Postgres-R, see www.postgres-r.org And I'm
continuously working on it, despite not having updated the website for
almost a year now...
I planned on releasing the next development snapshot together with 8.3,
as that seems to be delayed,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jonah H. Harris wrote:
Certainly, but can one expect to get a realistic answer to an, is
Oracle fearing something question on he PostgreSQL list? Or was it
just a backhanded attempt at pushing the topic again? My vote is for
the latter; it
On Mon, Jun 18, 2007 at 02:16:56PM -0400, Jonah H. Harris wrote:
pgsql-advocacy... your thoughts?
I've picked -advocacy.
I think the Oracle discussion is over, David T. just needs URL references
IMHO.
I don't think we can speak about Oracle; if we were licenced, we'd be
violating it, and
On Mon, Jun 18, 2007 at 02:38:32PM -0400, Andrew Sullivan wrote:
I've picked -advocacy.
Actually, I _had_ picked advocacy, but had an itchy trigger finger.
Apologies, all.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
A certain description of men are for getting out of debt, yet are
against all
Hi,
Craig James wrote:
Is Postgres-R the same thing as Slony-II? There's a lot of info and
news around about Slony-II, but your web page doesn't seem to mention it.
Hm... true. Good point. Maybe I should add a FAQ:
Postgres-R has been the name of the research project by Bettina Kemme et
Hi,
I have an application which really exercises the performance of
postgresql in a major way, and I am running into a performance
bottleneck with Postgresql 8.1 that I do not yet understand.
Here are the details:
- There is a primary table, with some secondary tables
- The principle
This is my idea:
A JavaScript HTML page that would have some basic questions at the top:
1) How much memory do you have?
2) How many connections will be made to the database?
3) What operating system do you use?
4) Etc…
Next the person would press a button, “generate”, found below the
Karl Wright wrote:
Hi,
I have an application which really exercises the performance of
postgresql in a major way, and I am running into a performance
bottleneck with Postgresql 8.1 that I do not yet understand.
Here are the details:
- There is a primary table, with some secondary tables
-
On 6/18/07, Sabin Coanda [EMAIL PROTECTED] wrote:
Hi Guillaume,
I tried pgFouine.php app on a sample log file but it reports me some errors.
Could you give me some startup support, please ?
I attach the log here to find what's wrong.
Sorry for the delay. I answered to your private email this
On 6/18/07, Y Sidhu [EMAIL PROTECTED] wrote:
I am following this discussion with great interest. I have PG running on
FreeBSD and am forced to run pgFouine on a separate Linux box. I am hoping I
can create a log file. and then copy that over and have pgFouine analyze it
on the Linux box.
a. I
On Mon, 18 Jun 2007, Campbell, Lance wrote:
The postgresql.conf settings would be tailored more to the individuals
needs than the standard default file. The second Iframe would contain
the default settings one should consider using with their operating
system.
I'd toyed with making a
On Jun 18, 2007, at 4:09 PM, [EMAIL PROTECTED] wrote:
one thing to point out to people about this idea is that nothing
says that this page needs to be served via a webserver. If all the
calculations are done in javascript this could be a local file that
you open with a browser.
do any
On Mon, 18 Jun 2007, [EMAIL PROTECTED] wrote:
do any of the text-mode browsers implement javascript?
http://links.twibright.com/
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 3: Have you
Karl Wright [EMAIL PROTECTED] writes:
- At any given time, there are up to 100 of these operations going on at
once against the same database.
It sounds like your hardware is far past maxed out. Which is odd
since tables with a million or so rows are pretty small for modern
hardware. What's
35 matches
Mail list logo