[ADMIN] Handling of images via Postgressql

2010-04-07 Thread Suresh Borse
How does PostGreSQL perform in case we have to store and use huge no of images: Eg 4000 – 1 images, each approx 2 MB size. The Questions that we have are: How do we handle such huge no of images so that the application does not slow down? How does PostGreSQL use caching? In case of im

Re: [ADMIN] ERROR: syntax error at or near "group"

2009-12-28 Thread Suresh Borse
ally stated. Any review, > retransmission, dissemination or other use of, or taking of any action > in reliance upon, this information by persons or entities other than > the intended recipient is prohibited. If you received this email in > error, please contact the sender and delete the em

Re: [ADMIN] Log full with gigabyes of CurTransactionContex

2009-06-15 Thread Suresh Borse
nsactionContext: 8192 total in 1 blocks; 8176 free (5 chunks); > 16 used > CurTransactionContext: 8192 total in 1 blocks; 8176 free (5 chunks); > 16 used > CurTransactionContext: 8192 total in 1 blocks; 8176 free (5 chunks); > 16 used > CurTransactionContex

Re: [ADMIN] Log full with gigabyes of CurTransactionContex

2009-06-15 Thread Suresh Borse
chunks); > 16 used > CurTransactionContext: 8192 total in 1 blocks; 8176 free (5 chunks); > 16 used > CurTransactionContext: 8192 total in 1 blocks; 8176 free (5 chunks); > 16 used > CurTransactionContext: 8192 total in 1 blocks; 8176 free (5 chunks); > 16 used >

[ADMIN] How to migrate from oracle to postgres !!

2009-01-30 Thread Suresh Borse
Dear All, How to migrate existing database which in Oracle to postgres? Please provide me the solution/limitation for triggers , procedure , packages & views while migrating. Thanks & Regards, Suresh Borse (DBA)

Re: [ADMIN] primary key and insert

2008-12-11 Thread Suresh Borse
;$txtStudentAlert', > 'now()' > )"; > > How do I do an insert on this table and have the primary key "id" > update with the record? > > thanks > > Marc Thanks & Regards, Suresh Borse (DBA)

Re: [ADMIN] Heavy postgres process

2008-12-10 Thread Suresh Borse
us checks before opening the e-mail or attachment. Infosys reserves > the > right to monitor and review the content of all messages sent to or from this > e-mail > address. Messages sent to or from this e-ma

Re: [ADMIN] dba and tables spaces questions

2008-12-08 Thread Suresh Borse
"will this be a > valid cmd ? Or other solution to this issues ? > using Pg version 8.3 on Linux > Thank you in advance > Isabella > > > Thanks & Regards, Suresh Borse (DBA) _

Re: [ADMIN] change user passwd

2008-12-01 Thread Suresh Borse
properties & change the password. On Mon, 2008-12-01 at 12:50 -0800, Isabella Ghiurea wrote: > I'm using PG 8.3.4 , what's the method for remote users to change > their PG passwd . > Isabel

Re: [ADMIN] query optimization

2008-07-10 Thread Suresh Borse
the result was same. The view contains multi-table joins. Warm Regards, Suresh Borse On Thu, 2008-07-10 at 12:25 +0300, Julius Tuskenis wrote: > Hello, Suresh > > Maybe its taking long for the first time, and then its faster? Did you > noticed any circumstances under witch your

[ADMIN] query optimization

2008-07-10 Thread Suresh Borse
anges for each execution. Can anybody help me for troubleshooting and for resolving the performance issue. Thanks & Regards, Suresh Borse