"Guy Rouillier" <[EMAIL PROTECTED]> writes:
> Greer, Doug wrote:
>> I am interested in using Postgresql for a dB of hundreds of
>> millions of rows in several tables. The COPY command seems to be way
>> too slow. Is there any bulk import program similar to Oracle's SQL
>> loader for Postgresql? S
Greer, Doug wrote:
> Hello all,
> I am interested in using Postgresql for a dB of hundreds of
> millions of rows in several tables. The COPY command seems to be way
> too slow. Is there any bulk import program similar to Oracle's SQL
> loader for Postgresql? Sincerely,
> Doug Greer
We'
I think XA will be in 8.1 and 8.1 might be a year away from release.
---
Horst G. Reiterer wrote:
> Hi,
>
> a native application of ours is based on distributed transactions and thus
> requires all databases to provide an X
Title: hundreds of millions row dBs
Hello all,
I am interested in using Postgresql for a dB of hundreds of millions of rows in several tables. The COPY command seems to be way too slow. Is there any bulk import program similar to Oracle’s SQL loader for Postgresql?
Sincerely,
Dou
hi
I saw your mailing list and I was wondering if postgresql works with Mailwatch
yet?
_
OFiR Spil - Vind 1.000 vis af kroner! Besøg http://spil.ofir.dk
OFiR Kontakt - Find din nye ven el. partner på http://kontakt.ofir.dk
-
On Mon, Jan 03, 2005 at 09:21:46PM +0100, Peter Eisentraut wrote:
> Robby Russell wrote:
> > agreed. Font sizes are a little 'too' small in some areas. The font
> > size for the body is set to "font-size: 69%;"
> >
> > maybe 72% would be a little less of a strain. ;-)
>
> It might be too obvious,
Am Montag, den 03.01.2005, 21:04 + schrieb Luis Neves:
> Peter Eisentraut wrote:
> > Robby Russell wrote:
> >
> >>agreed. Font sizes are a little 'too' small in some areas. The font
> >>size for the body is set to "font-size: 69%;"
> >>
> >>maybe 72% would be a little less of a strain. ;-)
> >
Not quite, see here for more information:
http://www.thenoodleincident.com/tutorials/typography/index.html
Unfortunately, on my Opera 7 for Linux, this page is illegibly small
(something like font-size: 7px) ; so I did not read it.
I always use sizes in pixels. It works in IE6, Mozilla, and Op
Martijn van Oosterhout writes:
On Mon, Jan 03, 2005 at 02:32:44PM +0200, [EMAIL PROTECTED] wrote:
Hi,
I have the following problem:
I use libpq inside SRF functions (like in dblink) and I create some tables
to store results coming from remotly executed queries. (These tables are
not tempo
On Mon, Jan 03, 2005 at 02:32:44PM +0200, [EMAIL PROTECTED] wrote:
> Hi,
>
> I have the following problem:
>
> I use libpq inside SRF functions (like in dblink) and I create some tables
> to store results coming from remotly executed queries. (These tables are
> not temporary cause I want to
Peter Eisentraut wrote:
Robby Russell wrote:
agreed. Font sizes are a little 'too' small in some areas. The font
size for the body is set to "font-size: 69%;"
maybe 72% would be a little less of a strain. ;-)
It might be too obvious, but in my mind the only correct setting for the
body on any web
You can't use LEFT JOINs or really any kind of explicit join in a
DELETE query (deficiency of the SQL standard). If you need a LEFT JOIN
you probably need a subselect, like:
DELETE FROM table WHERE primary_key IN
(SELECT primary_key FROM x LEFT JOIN y WHERE etc..)
or any of the equivalent form
> It might be too obvious, but in my mind the only correct setting for the
> body on any web site is "font-size: 100%".
I tend to agree. Forcing a smaller font size is almost always an indication
that you're trying to cram too much stuff on the page.
The choice of font colors is also question
Robby Russell wrote:
> agreed. Font sizes are a little 'too' small in some areas. The font
> size for the body is set to "font-size: 69%;"
>
> maybe 72% would be a little less of a strain. ;-)
It might be too obvious, but in my mind the only correct setting for the
body on any web site is "font-s
gives me (and those on high) the warm-fuzzies. If I store files (PDFs
of varying sizes by the way, say from 500k to 50M) as large objects,
will I still be able to restore the _whole_ database from a single
pg_dump tar file?
Don't forget a thing :
If you put a webserver in front of this
If this is done as a stored procedure, won't transaction semantics
prevent it from being a problem when two transactions attempt this
simultaneously? I'd thought that the output of one would become the
input of the other (in essence, in terms of database state)?
Well, for this you need to
Increase logging, and check the log for errors.
On Thu, 30 Dec 2004 23:44:51 -0600, Eric Scott <[EMAIL PROTECTED]> wrote:
> Heya;
> I have PostGreSQL 7.3.4 on Mandrake Linux 9.2. For some reason Webmin,
> when I tell it to change the password of a pgsql user, acts like it's
> working, but still
On Sat, 2005-01-01 at 19:50 -0600, Dan Boitnott wrote:
> On Jan 1, 2005, at 11:40 AM, Joshua D. Drake wrote:
>
> >
> >>>
> >> Intresting.
> >> What is the size when bytea become inafective ?
> >>
> >> Currently i keep all my products images in bytea record. is it
> >> practical ?
> >
> > Well I a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
That sounds promising, but I was hoping to avoid a custom function. Oh
well, I'll get to work on it when I get back from lunch.
If this is done as a stored procedure, won't transaction semantics
prevent it from being a problem when two transactions
Hi,
Please CC me as I'm not on the list.
I'm trying to write a closed frequent itemset data mining custom
function for postgresql. The optimal interface for this function would
be something like the following:
CREATE OR REPLACE FUNCTION cfi( relation, integer ) RETURNS SETOF record
AS 'dmf
Does anyone use citext,
http://gborg.postgresql.org/project/citext/projdisplay.php, the case
insensitive text datatype?
Are there any negative ramifications in using a type such as citext instead
of a varchar?
Is there a real difference between text and varchar in PostGeSQL?
Thank you
Sim
There is only one installation of PostGreSQL on this machine.
It is a 8.0 beta 1
This is running on a RedHat 8 box and the initial setup did not include any
database. I downloaded and installed PostGreSQL from source.
I noticed that all the directories under /usr/local/pgsql except "data" were
ow
Heya;
I have PostGreSQL 7.3.4 on Mandrake Linux 9.2. For some reason Webmin,
when I tell it to change the password of a pgsql user, acts like it's
working, but still leaves "requires password" set to "no." I've tried
running psql and executing "ALTER USER [username] WITH PASSWORD
'[password]'
It seems that my mail never arrive to the mailing list.
--- Begin Message ---
Hi,
I have spend some time to read the very interesting feature LISTEN /
NOTIFY. I have found a lot of documentation on how to use in psql but
nothing on how to use in Perl DBI program. I don't know if it works.
I'll be
On Jan 1, 2005, at 11:40 AM, Joshua D. Drake wrote:
Intresting.
What is the size when bytea become inafective ?
Currently i keep all my products images in bytea record. is it
practical ?
Well I am going to make the assumption that you product images are
small...
sub 100k or something. Bytea is
Jeff Davis wrote:
> Does this release incorporate a change to the bgwriter or was it
> determined to leave it as-is until 8.1?
There are no bgwriter changes in RC3. We don't know yet if they will be
in 8.0 final.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candl
On Mon, Jan 03, 2005 at 08:29:18AM -0600, Jason Tesser wrote:
> I am new to postgres stored procedures and would like a little help. My
> function basically takes 2 arguments and inserts data into a table from
> a select statement. I want it to return the number of records inserted.
See "Obtain
You could also say you can have 2^N databases and 2^(63-N) records in
each database, and use a BIGSERIAL with the N higher bits pointing to the
DB number, and the 63-N lower bits being the actual serial... faster than
strings for indexing, and you init the serial to start at the first value
SELECT max, then treat the string as a sequence of characters and
increment the last character, rippling the carry if there is one :
carry = 1
l = len(s)-1
while carry and l>=0:
c = s[l]
c += carry
if c>max_allowed_char:
c = min_allowed_char
On Mon, 2005-01-03 at 10:53, Frank D. Engel, Jr. wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Is there any "convenient" way to generate (on request) a unique value
> for a TEXT column? I have a situation in which I want users of my
> front-end program to be able to manually ente
Frank,
El 03/01/2005 10:53 AM, Frank D. Engel, Jr. en su mensaje escribio:
Is there any "convenient" way to generate (on request) a unique value
for a TEXT column? I have a situation in which I want users of my
front-end program to be able to manually enter values for this column,
but if they l
Hi Frank
I use the following constructs to generate an objectid's in my database:
CREATE SEQUENCE public.tsfraction MAXVALUE 99;
CREATE FUNCTION getobjectid() RETURNS text
AS '
select((select(to_char(current_timestamp, \'-mm-dd-hh-mm-ss\'))) ||
(select(to_char((nextval(\'tsfract
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Is there any "convenient" way to generate (on request) a unique value
for a TEXT column? I have a situation in which I want users of my
front-end program to be able to manually enter values for this column,
but if they leave it blank (in the front-e
anon permutation wrote:
For performance reasons, each branch must has its own database and a
centralized transactional system is not an option.
I was considering just centralizing primary keys generation, but that
seems very slow too.
Segmenting primary keys among the branches is doable, but it
RPMs of PostgreSQL 8.0.0 Release Candidate 3 for SUSE LINUX 9.0 and
newer (including SLES9) have just been uploaded to the SUSE FTP server
and can be found under
ftp://ftp.suse.com/pub/projects/postgresql/postgresql-8.0.0rc3
Feel free to try them and send me bug reports and other feedback
r
I am new to postgres stored procedures and would like a
little help. My function basically takes 2 arguments and inserts data into a table
from a select statement. I want it to return the number of records inserted.
I am not sure what the best way to do this is. Here is my function
On Jan 2, 2005, at 8:31 PM, Tom Lane wrote:
Timothy Perrigo <[EMAIL PROTECTED]> writes:
On Jan 2, 2005, at 12:58 PM, Tom Lane wrote:
I think you probably are trying to run two postmasters at once. You
really need to increase the OS X memory limits, instead.
No, I just ran pg_ctl status to check,
Hi,
I have the following problem:
I use libpq inside SRF functions (like in dblink) and I create some tables
to store results coming from remotly executed queries. (These tables are not
temporary cause I want to use them later as a form of cache.) Then I try to
open these tables to get the r
What do you suggest?
In your reporting tool, I suggest you to use (branch_id,
local_primary_key) as a primary key. This way they are guaranteed unique.
Thanks.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
ht
Hi,
I am working on a application and I need some advice on the data warehousing
aspect of it. The situation is like this: I have an application that will
be used at each one of my branch offices. Each branch office is autonomous
and each has its own instance of the db. There is currently no
vinita bansal wrote:
Hi,
The function "CHAR in db2" returns a fixed length character string
representation of an integer number.What is the corresponding function
in Postgres?
Regards,
Vinita Bansal
http://www.postgresql.org/docs/7.4/interactive/functions-string.html
Mike Mascari
---
41 matches
Mail list logo
