Hi all,
Ia a Guy from Germany an a strong Postgres believer!
It is the best OpenSource Database i have ever have bee tasted and i
try to using
it in any Database Environments.
It is exiting to see thadt Verison 8.0 has Tablespaces like ORACLE and DB/2,
but i need Partitioning on a few very large
Hi all again,
My next queststion is dedicated to blobs in my Webapplication (using
Tomcat 5 and JDBC
integrated a the J2EE Appserver JBoss).
Filesystems with many Filesystem Objects can slow down the Performance
at opening
and reading Data.
My Question:
Can i speedup my Webapplication if i sto
Which filesystems? I know ext2 used to have issues with many-thousands
of files in one directory, but that was a directory scanning issue
rather than file reading.
From my Point of view i think it is better to let one Process do the
operation to an Postgres Cluster Filestructure as
if i bypass
Hmm,
I have asked some Peoples on the List an some one has posted this links
http://archives.postgresql.org/pgsql-performance/2004-12/msg00101.php
It is quite usefull to read but iam not sure thadt theese Trick is verry
helpfull.
I want to splitt my 1GByte Table into some little Partitions but ho
unsubscribe-digest
___
Gesendet von Yahoo! Mail - Jetzt mit 1GB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de
---(end of broadcast)---
TIP 2: D
I have a database of hundreds of millions of web links (between sites)
in Postgres. For each link, we record the url, the referer, and the
most recent date the link exists. I'm having some serious performance
issues when it comes to writing new data into the database.
One machine is simply not g
Hi,
I'm trying to include a custom function in my SQL-queries, which
unfortunately leaves the server hanging...
I basically search through two tables:
* TABLE_MAPPING: lists that 'abc' is mapped to 'def'
id1 | name1 | id2 | name2
-
1 | abc | 2 | def
3 | uvw
I know in mysql, index will auto change after copying data
Of course, index will change after inserting a line in postgresql, but what
about copying data?
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hey Everyone,
I am having a bit of trouble with a web host, and was wondering as what
you would class as a high level of traffic to a database (queries per
second) to an average server running postgres in a shared hosting
environment (very modern servers).
Many Thanks in Advance,
Oliver
---
Hi all,
I'm using Postgresql 8.2.3 on a Windows XP system.
I need to
write and retrieve bytea data from a table.
The problem is that, while
data insertion is quite fast, bytea extraction is very slow.
I'm trying
to store a 250KB image into the bytea field.
A simple select query on a
36-row tab
Thanks for your reply,
>Is it in executing the query (what does
EXPLAIN ANALYSE show)?
Here is the output of explain analyze SELECT *
FROM "FILE"
"Seq Scan on "FILE" (cost=0.00..1.36 rows=36 width=235)
(actual time=0.023..0.107 rows=36 loops=1)"
>How are you accessing
the database: odbc,
>If you look at the "actual time" it's completing very quickly indeed.
So
>- it must be something to do with either:
>1. Fetching/formatting
the data
>>2. Transferring the data to the client.
I do agree.
>What
happens if you only select half the rows? Does the time to run the
>select halve?
Massimo
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Hello List,
I'm using postgresql 7.4 on FC4.
When i run following query on postgresql prompt, it gives error.
indse96=# CREATE TEMP TABLE aggregate AS ( SELECT vc_vouchno
,vc_srno,vc_type ,vc_vouchdt,trim(''),vc_descrip, ( CASE WHEN
(vc_dr_cr='D') THEN vc_amount ELS
We need to upgrade a postgres server. I'm not tied to these specific
alternatives, but I'm curious to get feedback on their general
qualities.
SCSI
dual xeon 5120, 8GB ECC
8*73GB SCSI 15k drives (PERC 5/i)
(dell poweredge 2900)
SATA
dual opteron 275, 8GB ECC
24*320GB SATA II 7.2k d
On Apr 3, 2007, at 6:54 PM, Geoff Tolley wrote:
I don't think the density difference will be quite as high as you
seem to think: most 320GB SATA drives are going to be 3-4 platters,
the most that a 73GB SCSI is going to have is 2, and more likely 1,
which would make the SCSIs more like 50%
On Apr 4, 2007, at 12:09 PM, Arjen van der Meijden wrote:
If you don't care about such things, it may actually be possible to
build a similar set-up as your SATA-system with 12 or 16 15k rpm
SAS disks or 10k WD Raptor disks. For the sata-solution you can
also consider a 24-port Areca card.
In a perhaps fitting compromise, I have decide to go with a hybrid
solution:
8*73GB 15k SAS drives hooked up to Adaptec 4800SAS
PLUS
6*150GB SATA II drives hooked up to mobo (for now)
All wrapped in a 16bay 3U server. My reasoning is that the extra SATA
drives are practically free compared t
On Apr 5, 2007, at 8:21 AM, Jeff Frost wrote:
I noticed this behavior on the last Areca based 8 disk Raptor
system I built. Putting pg_xlog on a separate partition on the same
logical volume was faster than putting it on the large volume. It
was also faster to have 8xRAID10 for OS+data+pg
t, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
I can't speak to "the access mode of the SQL statement" but it looks
like the index that you are looking for is an index on an expression,
as shown in:
http://www.postgresql.org/docs/8.0/static/indexes-expressional.html
You probably want a btree on UPPER(municipo), if that is the primary
query me
Thanks Magnus,
So are we correct to rely on
- 8 being slower than 7.x in general and
- 8 on Win32 being a little faster than 8 on Cygwin?
Will the final release of 8 be faster than the beta?
Thanks,
Mike
- Original Message -
From: "Magnus Hagander" <[EMAIL PROTECTED]
Hi,
We are experiencing slow performance on 8 Beta 2 Dev3 on Win32 and are
trying to determine why. Any info is appreciated.
We have a Web Server and a DB server both running Win2KServer with all
service packs and critical updates.
An ASP page on the Web Server hits the DB Server with a simple q
same java process takes 5 minutes! Postgres is a great DB for some,
for our application it was not - you may want to consider other products
that are a bit faster and do not require the vacuuming of stale data.
Original Message:
-
From: vivek singh [EMAIL PROTECTED]
Date: Sat, 1
Hi,
in March there was an interesting discussion on the list with the
subject "postgres eating CPU on HP9000".
Now I'm the same problem on a Dell dual processor machine.
Anybody know if there was a solution?
Thanks
Piergiorgio
---(end of broadcast)-
Josh Berkus wrote:
in March there was an interesting discussion on the list with the
subject "postgres eating CPU on HP9000".
Link, please?
http://archives.postgresql.org/pgsql-performance/2004-03/msg00380.php
---(end of broadcast)---
TIP
Hello all,
I'm doing tests on various Database and in particular I'm running a
comparison between Oracle 10g and Postgres 8.1 on a dedicated server
with 2 processors Dual-Core AMD Opteron 2218 2.6 GHz, 4GB of memory
and Debian GNU / Linux version 2.6.18-5. Performance is very similar up
to 30
> I find myself having to do this in Sybase, but it sucks because there's
> a race - if there's no row updated then there's no lock and you race
> another thread doing the same thing. So you grab a row lock on a
> sacrificial row used as a mutex, or just a table lock. Or you just
> accept that some
Hi,
In my pgsql procedure, i use the function
geometryDiff := difference
(geometry1,geometry2);
but this function is very slow!!!
What can I do to
speed this function?
Exists a special index for it?
Thanks in advance!
Luke
--
Sent via pgsql-performance mailing list (pgsql-performance@postgre
Στις Wednesday 09 July 2008 03:47:34 ο/η [EMAIL PROTECTED] έγραψε:
> On Tue, 8 Jul 2008, Tom Lane wrote:
> > Jeff <[EMAIL PROTECTED]> writes:
> >> On Jul 8, 2008, at 8:24 AM, Achilleas Mantzios wrote:
> >>> File sizes of about 3M result in actual logging outpu
>In FreeBSD 7.0 by default it does not fsync (except for kernel messages),
>unless the path is prefixed by "-" whereas it syncs.
Sorry, scrap the above sentence.
The correct is to say that FreeBSD 7.0 by default it does not fsync(2) (except
for kernel messages), and even in this case of kernel me
Στις Tuesday 08 July 2008 21:34:01 ο/η Tom Lane έγραψε:
> Achilleas Mantzios <[EMAIL PROTECTED]> writes:
> > Στις Tuesday 08 July 2008 17:35:16 ο/η Tom Lane έγραψε:
> >> Hmm. There's a function in elog.c that breaks log messages into chunks
> >> for syslo
33 matches
Mail list logo