How good is Postgres' performance for massive simultaneous insertions
into the same heavily-indexed table? Are there any studies or
benchmarks I can look at for that?
I understand Postgres uses MVCC rather than conventional locking, which
makes it easier to do parallel inserts. In my environm
UNSUBSCRIBE
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On 1/5/04 4:29 PM, Michael Glaesemann wrote:
> (If you're not the John Siracusa who writes for Ars Technica, the
> sentiment still holds. :) )
I am everywhere!
(worked, thanks to both of you who replied :)
-John
---(end of broadcast)---
TIP 3: if
Hi John!
On Jan 5, 2004, at 3:00 PM, John Siracusa wrote:
How can I create a non-null date column that defaults to 'now' as
computed
at the time the row is inserted?
How about this?
test=# create table johns (comment text not null,this_time timestamp
not null default now(), this_date date not
On Mon, 2004-01-05 at 21:00, John Siracusa wrote:
> How can I create a non-null date column that defaults to 'now' as computed
> at the time the row is inserted?
The default should be either CURRENT_DATE or timeofday()::DATE
The difference is that CURRENT_TIME, CURRENT_TIMESTAMP and CURRENT_DATE
On Sun, 4 Jan 2004, A E wrote:
> Hi,
> Was wondering if there are ways to completely script a new postgresql
> installation. I need to be able to create the db, users, and db
> elements from one command so that I can included it in a setup
> routine.
How about pgbash. Is it still being supporte
How can I create a non-null date column that defaults to 'now' as computed
at the time the row is inserted?
-John
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
Perhaps a combination of those settings is what did it?
Maybe --- what was the failure message exactly, once you got it?
Managed to fix it before I got any errors actually. Simple enough to
re-break it however:
FATAL: max_fsm_pages must exceed max_fsm_relations * 16
Looks like I was 6 short
Bruce Momjian wrote:
> Gaetano Mendola wrote:
> > No one will be at the next fosdem ?
>
> They haven't invited us. Peter was going to check but I haven't
> heard back from him.
I will be in attendance, but as far as I know there isn't going to be
anyone holding a talk about PostgreSQL or somethi
On Mon, 5 Jan 2004, Gregory Stone wrote:
> I have a need to run postgres only when my Java application is running.
> Basically I want to do a Runtime.exec() from java in order to start up the
> DB server. Is there any reason why this should present a problem? My
> init.d script is su-ing to the pg
I have a need to run postgres only when my Java application is running.
Basically I want to do a Runtime.exec() from java in order to start up the
DB server. Is there any reason why this should present a problem? My
init.d script is su-ing to the pguser before launching pg_ctl with all the
various
On Mon, 5 Jan 2004, Marek Lewczuk wrote:
> Dave Cramer wrote:
> > connection failed :(
> works for me... :-) (poland)
>
We have small downtime because of upgrading server software, so this may
be a reason for the problem. We're in stage of optimizing crawler because
some sites are very-very ugly,
On Tue, Jan 06, 2004 at 12:50:05AM +0900, Alex wrote:
> Yup, DMA is not enabled, probably that is the problem. Tried to enable
> it but get an error HDIO_SET_DMA failed: Operation not permitted.
probably You have no support for Your boards chipset enabled. You
can do this ether by loading the pro
Dave Cramer wrote:
connection failed :(
works for me... :-) (poland)
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Yup, DMA is not enabled, probably that is the problem. Tried to enable
it but get an error HDIO_SET_DMA failed: Operation not permitted.
Thanks for the hint.
Alex
Doug McNaught wrote:
Alex <[EMAIL PROTECTED]> writes:
The old system has a 80GB, 5200rpm ATA , the new system a 120GB,
7200rpm A
Hi there,
I'm pleased to present pilot version of http://www.pgsql.ru - search system on
postgresql related resources. Currently, we have crawled 27 sites,
new resources are welcome. It has multi-languages interface (russian, english)
but more languages could be added. We plan to add searchable ar
Hmmm, I've always used plpgsql.so (also formerly known
as libplpgsql.so, I think...) as in:
CREATE FUNCTION plpgsql_call_handler () RETURNS language_handler
AS '/usr/lib/plpgsql.so', 'plpgsql_call_handler'
LANGUAGE c;
CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER
pl
unsubscribe
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
unsubscribe
---(end of broadcast)---
TIP 8: explain analyze is your friend
Alex <[EMAIL PROTECTED]> writes:
> The old system has a 80GB, 5200rpm ATA , the new system a 120GB,
> 7200rpm ATA. The new system should at least not be slower. Also, on
> the new system I have a separate partition for the database.
>
> If I run a Vacuum or a SELECT COUNT(*) on a larger table (2-6
[EMAIL PROTECTED] says...
> err... i think you misunderstood... I'm was looking for a link to show the
> mozilla folks saying they would stop using the firebird name. I've never
> heard such a thing, while I have heard the opposite, and the info you site
> above only seems to verify that mozi
May I suggest that Appendix E also includes release date for each
release, and also lists tentative/planned features for future releases
(say: in 7.5, win32 port and 2-phase commit; in 8.0, ...; etc).
This is like Appendix D of the MySQL documentation. It gives
outsiders/beginners like me a bet
Hi Octavio;
I have had to do something like this (hotel reservation app I am developing)
and want to be able to reconstruct an accurate picture of the database from
any point in time for reporting purposes (suppose I change the configuration
of a room and want to see vacancy rate info for a certai
The old system has a 80GB, 5200rpm ATA , the new system a 120GB, 7200rpm
ATA. The new system should at least not be slower. Also, on the new
system I have a separate partition for the database.
If I run a Vacuum or a SELECT COUNT(*) on a larger table (2-6 million
records) the systems responds v
Alex <[EMAIL PROTECTED]> writes:
> Hi,
> I just installed pg 7.4.1 on a new system P4, 3.2Gh HT, 1GB Mem, RH9
> and discovered that some of the processes have become extremely
> slow. Mainly I am talking about a SELECT COUNT(*) or VACUUM.
>
> Before running the same database on a P4. 2Ghz 412MB me
On Mon, 5 Jan 2004, Tom Lane wrote:
> Mark Kirkwood <[EMAIL PROTECTED]> writes:
> > These results seem pretty good to me...
>
> FWIW, I see pretty decent search speed when I go to
> http://www.postgresql.org/search.cgi
> but pretty lousy search speed when I try a similar query at
> http://archives
Hi,
I just installed pg 7.4.1 on a new system P4, 3.2Gh HT, 1GB Mem, RH9 and
discovered that some of the processes have become extremely slow. Mainly
I am talking about a SELECT COUNT(*) or VACUUM.
Before running the same database on a P4. 2Ghz 412MB mem, I got the job
done in some cases half t
Try www.pgsql.ru. I just released pilot version with full text searching
postgresql related resources. Search for security invoker takes 0.03 sec :)
Oleg
On Thu, 1 Jan 2004, ezra epstein wrote:
> Yup,
>
> So slow in fact that I never use it. I did once or twice and gave up.
> It is i
Mark Kirkwood <[EMAIL PROTECTED]> writes:
> These results seem pretty good to me...
FWIW, I see pretty decent search speed when I go to
http://www.postgresql.org/search.cgi
but pretty lousy search speed when I try a similar query at
http://archives.postgresql.org/
Could we get the latter search
> The searches are designed so that you can do sub-section searches ... ie.
> if you only wanted to search hackers, the LIKE would be:
>
> 'http://archives.postgresql.org/pgsql-hackers/%%'
>
> while:
>
> 'http://archives.postgresql.org/%%'
>
> would give you a search of *all* the mailing lists
unsubscribe
I just tried :
i) "wal" in "7.4 docs" -> 5 seconds
ii) "partial index" in "All Sites" -> 3 seconds
iii) "column statistics" in "All Sites" -> 2 seconds
iv) "fork exec" in "All Sites" -> 2 seconds
These results seem pretty good to me...
regards
Mark
---(end of broad
Gregory Wood <[EMAIL PROTECTED]> writes:
> Perhaps a combination of those settings is what did it?
Maybe --- what was the failure message exactly, once you got it?
Also, if you hand-edited these settings, it's fair to ask what
the port package defaults are ...
regards, to
33 matches
Mail list logo
