I've dumped the big table from the original database (where it is 61 GB in size)
and am restoring it into a test database to see what the size is after
the restore.
As it is now, our DR is offline because we did not expect the database to
nearly double in size upon COPY of the data into a new data
We are going to design database for a large company with multi branches. I
am using PostgreSQL
For example,
I create a single database for all branches. After 10 years, database size
is too large.
I want to know ,at that time, the performance of the database is reduced or
not.
Is it possible to
On 02/23/11 1:33 PM, Tom Lane wrote:
The question is does he actually have a use-case for address ranges that
don't correspond to legal CIDR ranges, but do nonetheless have an
identifiable lower boundary, upper boundary, and no holes? And if so,
what is it? The whole thing looked to me like som
John R Pierce writes:
> On 02/23/11 4:44 AM, Stephane Bortzmeyer wrote:
> *3. Start-End IP format :* 1.2.3.0-1.2.3.255
>> You don't even need to program the conversion, it is already done:
>>
>> % netmask 1.2.3.0:1.2.3.255
>> 1.2.3.0/24
> yes, but what about 10.1.2.57-10.1.2.123 ?presum
On Mon, Feb 21, 2011 at 7:16 AM, Roman wrote:
> Hi,
> I have problem with deadlocks and don't know why it happens. Below is
> the log (postgres 9.0, debian):
>
> [11882]DETAIL: Process 11882 waits for ShareLock on transaction
> 44324308; blocked by process 11884.
> Process 11884 waits for
On Feb 23, 2011, at 13:49, John R Pierce wrote:
> On 02/23/11 4:44 AM, Stephane Bortzmeyer wrote:
>>> *3. Start-End IP format :* 1.2.3.0-1.2.3.255
>> You don't even need to program the conversion, it is already done:
>>
>> % netmask 1.2.3.0:1.2.3.255
>> 1.2.3.0/24
>
> yes, but what
On 02/23/11 4:44 AM, Stephane Bortzmeyer wrote:
*3. Start-End IP format :* 1.2.3.0-1.2.3.255
You don't even need to program the conversion, it is already done:
% netmask 1.2.3.0:1.2.3.255
1.2.3.0/24
yes, but what about 10.1.2.57-10.1.2.123 ?presumably valid in his
range sys
On 02/23/2011 09:23 AM, Rich Shepard wrote:
> On Wed, 23 Feb 2011, David Johnston wrote:
>
>> Why can you not just import the CSV as generated by Access?
>
> I don't want additional quotation marks on all text.
I haven't followed this thread too closely, so maybe I'm missing
something, but isn
> Running postgres 9.0.1 on Solaris 10 (Sparc)
> I am testing a development database before putting it in production. The
application install created the database and the indexes. When I run psql and
list the indexes \di I can count the number of indexes and see the names of the
indexes.
Le 23/02/2011 09:10, salah jubeh a écrit :
> [...]
> This is a simple way to check if there is no activity on the table,
>
> SELECT relname,seq_tup_read,idx_tup_fetch FROM pg_stat_user_tables
> WHERE (idx_tup_fetch + seq_tup_read)= 0;
>
>
> Is there is any way to make similar checks on views
Le 23/02/2011 09:58, Interrogativus a écrit :
> Hi there,
>
> I am currently running Version 1.12.2 (Dec 14 2010, rev: REL-1_12_2) /
> PostgreSQL 9.02 on Windows 7 Ultimate (64-bit)
>
> The problem is the exactly the same as described in this thread
> http://postgresql.1045698.n5.nabble.com/Error
On Wed, 23 Feb 2011, David Johnston wrote:
Why can you not just import the CSV as generated by Access?
I don't want additional quotation marks on all text.
Loading the 80 rows in OO.o Calc does let me see the problems and I'm
fixing them one-by-one. I didn't think of doing this.
Thanks,
runner writes:
> Running postgres 9.0.1 on Solaris 10 (Sparc)
> I am testing a development database before putting it in production. The
> application install created the database and the indexes. When I run psql
> and list the indexes \di I can count the number of indexes and see the names
Running postgres 9.0.1 on Solaris 10 (Sparc)
I am testing a development database before putting it in production. The
application install created the database and the indexes. When I run psql and
list the indexes \di I can count the number of indexes and see the names of the
indexes. If
On 2/22/2011 9:33 PM, John R Pierce wrote:
On 02/22/11 1:25 AM, Jaime Crespo Rincón wrote:
2011/2/22 Adarsh Sharma:
Dear all,
Today I need to back up a mysql database and restore in Postgresql
database
but I don't know how to achieve this accurately.
Have a look at: "mysqldump --compatible=po
Yup, I forgot the "^".
Works now.
Thanks !
From: David Johnston [mailto:pol...@yahoo.com]
Sent: Tuesday, February 22, 2011 7:26 PM
To: Gauthier, Dave; pgsql-general@postgresql.org
Subject: RE: [GENERAL] regexp match in plpgsql
You are trying to check the entire string to ensure only the specified
On Wednesday, February 23, 2011 6:11:16 am Rich Shepard wrote:
> On Tue, 22 Feb 2011, David Johnston wrote:
> > The data and table structure provided do not seem to correlate.
>
> David,
>
>That's the problem. However, they should match since they came from the
> same .mdb file.
>
> > Regard
Why does your transformed data repeat the first 5 columns out the original
CSV?
Why do values within a given field end up on different lines (e.g., SIERRA
MANOR, 39.44)?
Basically, your transform output as presented makes no sense to me; I don't
even see how you could import any records into Postg
On Tue, 22 Feb 2011, David Johnston wrote:
The data and table structure provided do not seem to correlate.
David,
That's the problem. However, they should match since they came from the
same .mdb file.
Regardless, if you changed the delimiter to "|" from "," it is possible that
you conver
Hi,
I found the issue and of course as you already suspected it was not postgres
related.
Thanks a lot for doing such a great job,
Ioana
--- On Fri, 2/18/11, Ioana Danes wrote:
> From: Ioana Danes
> Subject: [GENERAL] Logged statement apparently did not commited...
> To: pgsql-general@postgr
On Wed, Feb 23, 2011 at 05:39:26PM +0530,
Gaini Rajeshwar wrote
a message of 52 lines which said:
> I wanted to store ip addresses in table. I wanted to support the following 3
> types of ip addresses.
>
> *1. Wildcard format :* 1.2.3.*
> *
> *
> *2. CIDR format:* 1.2.
On Wed, Feb 23, 2011 at 02:30:18PM +0200,
Sim Zacks wrote
a message of 97 lines which said:
> a regular varchar or text field.
Very bad idea since they don't support canonicalization (2001:db8::1
== 2001:db8:0:0:0:0:0:1) or masking (set_masklen(address, 20)).
--
Sent via pgsql-general maili
a regular varchar or text field.
On 02/23/2011 02:09 PM, Gaini Rajeshwar wrote:
Hi All,
I wanted to store ip addresses in table. I wanted to support the
following 3 types of ip addresses.
|*1. Wildcard format :* 1.2.3.*
*
*|
|*2. CIDR format:* 1.2.3/24 OR 1.2.3.4/2
Hi All,
I wanted to store ip addresses in table. I wanted to support the following 3
types of ip addresses.
*1. Wildcard format :* 1.2.3.*
*
*
*2. CIDR format:* 1.2.3/24 OR 1.2.3.4/255.255.255.0
*
*
*3. Start-End IP format :* 1.2.3.0-1.2.3.255
I had a look at CIDR
On 23/02/2011 08:19, itishree sukla wrote:
Hi John,
Thanks for your reply, however the the address is starting with host
"58.137.154.189". It was working fine before, however not working in
new system.
Well, that's an IPv4 address, and as John said it looks as if your new
system is trying t
Is there a way to do ldap authentication in pg_hba on a structure that
has multiple ou objects?
Lets say I have an ou=Users and then an ou per dept.
I want the ldap to do authentication no matter which ou the user is in.
My current ldap string is:
ldap://ldap.server.local/Users;uid=;,ou=User
Hi there,
I am currently running Version 1.12.2 (Dec 14 2010, rev: REL-1_12_2) /
PostgreSQL 9.02 on Windows 7 Ultimate (64-bit)
The problem is the exactly the same as described in this thread
http://postgresql.1045698.n5.nabble.com/Error-with-pgAdmin-III-backup-restore-td3319910.html,
howev
Hi John,
Thanks for your reply, however the the address is starting with host
"58.137.154.189". It was working fine before, however not working in new
system.
On Wed, Feb 23, 2011 at 12:39 PM, John R Pierce wrote:
> On 02/22/11 10:38 PM, itishree sukla wrote:
>
>> Hi All,
>> I am using
Hello Guys,
This is a simple way to check if there is no activity on the table,
SELECT relname,seq_tup_read,idx_tup_fetch FROM pg_stat_user_tables
WHERE (idx_tup_fetch + seq_tup_read)= 0;
Is there is any way to make similar checks on views
Regards
Fr
29 matches
Mail list logo
