On 02/25/2011 05:11 PM, Gary Fu wrote:
On 02/25/11 17:22, Andy Colson wrote:
On 2/23/2011 12:31 PM, Gary Fu wrote:
Hi,
I'm testing on converting a big Sybase db to Pg. It took about 45 hours
to convert all sybase tables (bcp) to Pg (copy) without index and
reference. After that I built the ind
On 02/25/11 17:22, Andy Colson wrote:
On 2/23/2011 12:31 PM, Gary Fu wrote:
Hi,
I'm testing on converting a big Sybase db to Pg. It took about 45 hours
to convert all sybase tables (bcp) to Pg (copy) without index and
reference. After that I built the index (one by one, sequentially) and
it to
On Feb 25, 2011, at 6:24 PM, Craig Ringer wrote:
> In reality you must plan periodic updates, in which case it's quite likely
> that the growth of hardware and software performance will keep up with the
> data growth.
I've been in a lovely little niche that has fit that description since 1993 ;
On 24/02/2011 10:59 AM, Kalai R wrote:
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.
Oh yeah, for what it's worth: my employer has 10-year-old
On 24/02/2011 10:59 AM, Kalai R wrote:
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.
What is "too large?"
If you keep PostgreSQL up to date,
I'd also add: run pg_tune on your server. Made a *dramatic* difference for us.
On Friday, February 25, 2011 05:26:56 am Vick Khera wrote:
> On Thu, Feb 24, 2011 at 6:38 PM, Aleksey Tsalolikhin
>
> wrote:
> > In practice, if I pg_dump our 100 GB database, our application, which
> > is half Web f
Aleksey Tsalolikhin writes:
> Now just past weekend we upgraded our production server by pg_dump
> and pg_restore, and again the database is 109 GB in size!
Which character encoding of the source and target database?
--
Sergey Burladyan
--
Sent via pgsql-general mailing list (pgsql-general@p
Christine Penner wrote:
> I'm trying to do a select to find on a char field that has a single
> quote but getting errors. This is what I'm doing:
>
> Select * from f_buildings where B_STRET_LNE_CON='BERLETT\'S ROAD'
There are a couple of ways to do this in PG but the easiest and closest
to the s
On 2/23/2011 12:31 PM, Gary Fu wrote:
Hi,
I'm testing on converting a big Sybase db to Pg. It took about 45 hours
to convert all sybase tables (bcp) to Pg (copy) without index and
reference. After that I built the index (one by one, sequentially) and
it took about 25 hours and then I started to
VTD-XML 2.10 is now released. It can be downloaded at
https://sourceforge.net/projects/vtd-xml/files/vtd-xml/ximpleware_2.10/.
This release includes a number of new features and enhancement.
* The core API of VTD-XML has been expanded. Users can now perform
cut/paste/insert on an empty element.
On 25/02/2011 20:37, Rich Shepard wrote:
On Fri, 25 Feb 2011, Raymond O'Donnell wrote:
Upgrade to 1.12?
Ray,
That appears to have done the trick. I somehow thought I was working on
the latest version; it's been that sort of a week.
No problem - glad you're sorted.
Ray.
--
Raymond O'Donne
I'm trying to do a select to find on a char field that has a single
quote but getting errors. This is what I'm doing:
Select * from f_buildings where B_STRET_LNE_CON='BERLETT\'S ROAD'
The text I'm trying to find is BERLETT'S ROAD
If I do the same thing but have double quotes in the string inst
On Fri, 25 Feb 2011, Raymond O'Donnell wrote:
Upgrade to 1.12?
Ray,
That appears to have done the trick. I somehow thought I was working on
the latest version; it's been that sort of a week.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
Sweet Savings
it is really best place for online shopping
i had try , it is truth and service is very good
fast ship and best quality
hope you can try too
here is the site : :
sure you will like it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
On 25/02/2011 19:49, Rich Shepard wrote:
I'd like to use pgadmin3 for DDL tasks with an imported database. Using
version 1.10.2 on Slackware-13.1 with postgres-9.0.1. The application
starts. I learned to define the server as 'localhost' rather than the
hostname, so I can see entries in the left s
I'd like to use pgadmin3 for DDL tasks with an imported database. Using
version 1.10.2 on Slackware-13.1 with postgres-9.0.1. The application
starts. I learned to define the server as 'localhost' rather than the
hostname, so I can see entries in the left side, tree window. However,
pgadmin3 fail
On Fri, Feb 25, 2011 at 12:25 PM, runner wrote:
> I don't have a problem with blowing the database cluster away and starting
> over but I'd like to have a better understanding of what USE_FLOAT8_BYVAL
> does and how it affects our install. I spent a considerable amount of time
> googling this and
Using the 9.0.3 binaries from the PostgreSQL download site, Solaris 10 on
Sparc architecture.
I had a co-worker set up a development server using the 32 bit PostgreSQL
binaries for Solaris 10 Sparc. After some initial testing we realized we can't
take full advantage of the 16 GB of syste
On Wed, Feb 23, 2011 at 9:06 AM, Geoffrey Myers
wrote:
> I'm assuming you're saying you can replicate from an ASCII database to UTF8?
> What happens to the data that is not UTF8 'friendly?'
>
The assumption up-thread was that the data was already made UTF8
friendly in the US_ASCII database.
--
Reto Wittwer writes:
> Hello everyone
> I have the following error in my postgres-log:
> 2011-02-18 16:33:46.262 CET [2068:1] @ FEHLER: Speicher aufgebraucht
> 2011-02-18 16:33:46.262 CET [2068:2] @ DETAIL: Fehler bei Anfrage mit Größe
> 893716290.
Right offhand this looks like a corrupt-data pr
Gary Fu writes:
> I'm testing on converting a big Sybase db to Pg. It took about 45 hours
> to convert all sybase tables (bcp) to Pg (copy) without index and
> reference. After that I built the index (one by one, sequentially) and
> it took about 25 hours and then I started to add the referen
Vibhor Kumar wrote:
On Feb 22, 2011, at 10:23 PM, Jeff Amiel wrote:
It's come time to bite the bullet and convert a half-terraybyte database from
ASCII to UTF8. Have gone through a bit of effort to track down the unclean
ascii text and repair it but would like to avoid the outage of a many-m
Hello everyone
I have the following error in my postgres-log:
** ***
TopMemoryContext: 95584 total in 8 blocks; 4824 free (11 chunks); 90760 used
Operator class cache: 8192 total in 1 blocks; 3848 free (0 chunks); 4344 used
TopTransactionCont
Hi,
I looking for the best solution to backup files using WAL and warm standby.
I have 2 servers A and B. A is a main server (production) on B is runing
postgres with warm standby. I must now backup databases and WAL to tape
using a TSM, but on server standby if I using macro %r I have only few
Hi,
I'm testing on converting a big Sybase db to Pg. It took about 45 hours
to convert all sybase tables (bcp) to Pg (copy) without index and
reference. After that I built the index (one by one, sequentially) and
it took about 25 hours and then I started to add the references (one by
one),
Thank you all for the suggestion and it's very clear to me now
Regards
On Fri, Feb 25, 2011 at 10:02 AM, Bruce Momjian wrote:
> Adrian Klaver wrote:
> > test=# select to_timestamp('02/26/2011 14:50', 'MM/DD/ HH24MI');
> > to_timestamp
> >
> > 2011-02-26 14:
Adrian Klaver wrote:
> test=# select to_timestamp('02/26/2011 14:50', 'MM/DD/ HH24MI');
>
>
> to_timestamp
>
On Friday, February 25, 2011 6:41:54 am Reid Thompson wrote:
> On 02/25/2011 09:30 AM, akp geek wrote:
> > Hi all -
> >
> > I have recently upgraded from 8.3 to 9.0.2.
> >
> > when I run the following sql in 9.0.2 "select
> > to_timestamp('02/26/2011 14:50', 'MM/DD/ HH24MI') " I am gettin
Unfortunately the our database is still 8.3. that's a limitation for using
array_length
Regards
On Thu, Feb 24, 2011 at 4:08 PM, Dmitriy Igrishin wrote:
> Hey,
>
> 2011/2/24 akp geek
>
> Hi all -
>>
>> I am trying to find the number of elements in the array.
>> Right now I am usi
On 02/25/2011 09:30 AM, akp geek wrote:
Hi all -
I have recently upgraded from 8.3 to 9.0.2.
when I run the following sql in 9.0.2 "select to_timestamp('02/26/2011 14:50',
'MM/DD/ HH24MI') " I am getting the following
error and the sql runs fine in older version
Is it my installation
Create one sequence per owner and write a function/trigger that will check
the owner id for the record and call the appropriate nextval(sequence) to
get the next value for that owner and replace the id with the generated
value.
If new owner IDs are going to be generated, however, this will not be
On 2/25/2011 7:26 AM, Vick Khera wrote:
On Thu, Feb 24, 2011 at 6:38 PM, Aleksey Tsalolikhin
wrote:
In practice, if I pg_dump our 100 GB database, our application, which
is half Web front end and half OLTP, at a certain point, slows to a
crawl and the Web interface becomes unresponsive. I sta
Hi all -
I have recently upgraded from 8.3 to 9.0.2.
when I run the following sql in 9.0.2 "select to_timestamp('02/26/2011
14:50', 'MM/DD/ HH24MI') " I am getting the following error and
the sql runs fine in older version
Is it my installation issue or library missing?
ERROR: i
I cannot get the problem to appear using generated data and cannot provide
the real database.
Given these facts, and the fact I can use the "expanded" query to get the
necessary results, I am going to move on.
If you want me to provide any additional information with respect to this
behavior usin
On Thu, Feb 24, 2011 at 6:38 PM, Aleksey Tsalolikhin
wrote:
> In practice, if I pg_dump our 100 GB database, our application, which
> is half Web front end and half OLTP, at a certain point, slows to a
> crawl and the Web interface becomes unresponsive. I start getting
> check_postgres complaints
Dear All,
I've got a composite key in a table. The keys are ID and owner ID. The type of
the ID should be a serial, additionally I hope the ID to be increasable per
owner ID. ( The ID will be increased with the different owner ID) Does anyone
know how to implement it? Thanks in advance.
Best r
36 matches
Mail list logo
