On Jul 31, 2006, at 15:22 , Rafal Pietrak wrote:
Very sorry for that, 20-yrs old habits are really deap in your
bones. I
thought I've adjusted the subject accordingly, but I'll try to
remember
that for my future posts anyway.
Just a reminder: just changing the subject is not sufficient to
Ron Johnson wrote:
> I think I've read that there are multi-hundred GB PostgreSQL
> databases.
>
> Since pg_dump is single-threaded, how long does it take to back up
> such a database?
The evasive answer is that you probably don't run regular full pg_dump
on such databases.
> Are there any plans
Thanks Jim.
First, I appologize for double postings. Yahoo mail labelled all the
responses to this thread as spam, and but nothing else. So I was still
get mail in my inbox (pop), and therefore thought I was being ignore.
Second, I'm not too worried about the data being read in transit, unl
On Mon, 2006-07-31 at 12:55 +1000, Chris wrote:
> Rafal Pietrak wrote:
> > strop=# EXPLAIN ANALYZE SELECT * from users where username =
> > current_user;
> > QUERY
> > PLAN
> > -
On 7/29/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Buenas tardes,
Buenas,
te cuento que escribistes a una lista en ingles. te estoy
redireccionando a la lista en español...
Me gustaría saber las diferecias respecto a la gramática (tanto DML como
DDL) que tiene PostgreSql con ANSI SQL
Rafal Pietrak wrote:
Hi,
I've stapped over the following magic:
++
Table "public.users"
Column | Type |
Modifiers
--+--+--
On Jul 30, 2006, at 5:37 PM, Ashutosh wrote:
Currently I have a windows application that deals with reading and
writing patient information. At this moment each patient has its
individual ascii file and I use the fread and fwrite to read and write
files respectively. After being in existence fo
Hi,
I've stapped over the following magic:
++
Table "public.users"
Column | Type |
Modifiers
--+--+
id
Buenas tardes,
Me gustaría saber las diferecias respecto a la gramática (tanto DML como
DDL) que tiene PostgreSql con ANSI SQL 92. Querría saber hasta que punto se
puede afirmar su fidelidad con el estándar, y para aquellos casos en los que
no se puede aplicar la gramática, me gustaría saber s
Hello All,
Currently I have a windows application that deals with reading and
writing patient information. At this moment each patient has its
individual ascii file and I use the fread and fwrite to read and write
files respectively. After being in existence for 6 years now, I feel
strongly to movi
On Wed, 2006-07-26 at 13:38 -0700, Reece Hart wrote:
If you can release the data and get it to me (e.g., compressed email attachment, http, ftp), I volunteer to try a run on 8.1.4 on suse 10.0/x86_64.
Jaime-
I cannot replicate your observations.
There were 1915733 lines in the file yo
Tom,
Yes, I see. good to get that straightened out in my head, thank you.
-Meghan
Tom Lane
<[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Richard Huxton wrote:
> Karen Hill wrote:
>> How many tables can PostgreSQL theoretically and then
>> practically handle? What is the largest database size
>> possible? What was the biggest database you've ever had on
>> PostgreSQL? What were the ch
Tom Lane wrote:
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
Martijn van Oosterhout wrote:
It's the t_ctid field of the tuple header. But I don't see what that
has to do with "WHERE CURRENT OF". That expression should return the
tuple visible to your transaction, not some updated version whic
Martijn van Oosterhout writes:
It's still a reasonable suggestion. The maximum offset is the number of
rows in the table. You'll notice when the output is empty.
Once I find the point where the output is empty then what?
Do you have
an idea how much data it contains?
Yes. Around 87 million
On 7/29/06, gene Campbell <[EMAIL PROTECTED]> wrote:
I have a pg_hba.conf file that is setup like this
hostdb1 user1 222.152.155.194/32md5
From time to time, my ISP changes my ip address on me.
At that point, my connection to this DB is denied.
I have to log in (ssh) to my
Yes, you are right. I now tried to select from one table various amount of
records and when the amount exceeded some given number so the blks_hit begun
fall.
Thanks,
David Hoksza
30. července 2006, 20:24:33, napsal jste:
TL> David Hoksza <[EMAIL PROTECTED]
David Hoksza <[EMAIL PROTECTED]> writes:
> Hi, I'm not sure about the value idx_blks_hit of pg_statio_all_indexes
> view. Is it total value of touched pages, or do I get total value when
> I add idx_blks_read to it?
> In other words - does idx_blks_hit cover also physical reads?
I believe blks_hit
As per my understanding, 'pg_statio_all_indexes' displays "idx_blks_hit" using "pg_stat_get_blocks_hit(oid)" where the function "pg_stat_get_blocks_hit" gets number of disk block requests found in cache for a table or index.
Hope this helps...Thanks, -- Shoaib MirEnterpriseDB (www.enterprisedb.com)
Hi, I'm not sure about the value idx_blks_hit of pg_statio_all_indexes
view. Is it total value of touched pages, or do I get total value when
I add idx_blks_read to it?
In other words - does idx_blks_hit cover also physical reads?
Thanks,
David Hoksza
---(end of b
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
> Martijn van Oosterhout wrote:
>> It's the t_ctid field of the tuple header. But I don't see what that
>> has to do with "WHERE CURRENT OF". That expression should return the
>> tuple visible to your transaction, not some updated version which you
>>
Ron Johnson <[EMAIL PROTECTED]> writes:
> What's the inverse? Say I have a DATE and a TIME, and want to
> create a TIMESTAMP with them?
Add 'em together, using the "date + time" or "date + timetz" operator:
regression=# select current_date + '11:57'::time;
?column?
-
Martijn van Oosterhout wrote:
On Sun, Jul 30, 2006 at 04:37:26PM +0200, Florian G. Pflug wrote:
Martijn van Oosterhout wrote:
The word "become" is not really right. The old version has become
invisible to you and the new version is visible. Some other
transactions will see the old one, some the
On Sun, Jul 30, 2006 at 04:37:26PM +0200, Florian G. Pflug wrote:
> Martijn van Oosterhout wrote:
> >The word "become" is not really right. The old version has become
> >invisible to you and the new version is visible. Some other
> >transactions will see the old one, some the new one. However, ther
Martijn van Oosterhout wrote:
On Fri, Jul 28, 2006 at 12:00:19PM +0200, DANTE Alexandra wrote:
- is it correct to think that the ctid of the old version of the tuple
is a link to newer version ? In my example, is it correct to think that
the tuple :
140049|0 | (0,12) | 11 | IR
On Sun, Jul 30, 2006 at 01:31:14AM -0400, Francisco Reyes wrote:
> Looking at archives seem to indicate missing pg_clog files is some form
> of row or page corruption.
>
> In an old thread from back in 2003 Tom Lane recommended
> (http://tinyurl.com/jushf):
>
> >>If you want to try to narrow do
Christopher Browne wrote:
There's a demerit:
c) If there are a LOT of events, that might not fit in memory nicely.
If you have that many events then the current implementation is going to
suck hard as well:)
Keeping the listener structure in memory wouldn't be too bad.
I'd guess that each c
On Sun, Jul 30, 2006 at 10:00:30AM +0200, Andreas Kretschmer wrote:
> Ron Johnson <[EMAIL PROTECTED]> schrieb:
> > >> I know I can do a select to_date(now(),'-mm-dd') and it will return
> > >> the
> > >> date. However, how do I get the time? Also, is this the proper way to
> > >> get
> > >>
Ron Johnson <[EMAIL PROTECTED]> schrieb:
> >> I know I can do a select to_date(now(),'-mm-dd') and it will return the
> >> date. However, how do I get the time? Also, is this the proper way to get
> >> the date portion of a timestamp?
> >
> > select now()::timetz;
> > select now()::time;
> >
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alvaro Herrera wrote:
> Chris Hoover wrote:
>> I have several columns in my database that are timestamps. My developers
>> are asking me how to split the timestamp so that they can look at either the
>> date or at the time portion.
>>
>> I know I can
30 matches
Mail list logo
