Question: Does anyone have any idea what bottleneck I am hitting? An
index's performance should in theory scale as the log of the number of
rows - what am I missing here?
These can help people on the list to help you :
- Your hardware config (CPU, RAM, disk) ?
- E
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. Wh
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 c
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 of
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 of the text-mode browsers implement javascript? if so then you
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 Javasc
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.
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
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
- T
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
que
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 transac
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
al.
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
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, a
-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; i
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, th
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?
Ye
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 docu
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 le
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 wher
-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 vers
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
antagon
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
RTFM-l
-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
-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 flamewar-
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 www.postgre
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, t
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 fear
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 Manager/Softwa
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
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 goi
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
-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, 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.
--
Jo
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 wit
""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
Hello group,
Moreover a reindex (REINDEX 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:
Sent: Friday, June 15, 2007 7:15 PM
Subject: Re: [PERFORM] Databa
37 matches
Mail list logo
