Dumb i am.. nextval() already issued the next one to the sequence.
I probably dont need a separate table.
On Thu, Sep 16, 2010 at 4:17 PM, Aras Angelo wrote:
> Daniel, Craig
>
> The gaps are not really expected. It is set once only.
> Its about printing packing slips for ecommerc
perform better than a regular table index?
On Thu, Sep 16, 2010 at 4:06 PM, Craig James wrote:
> On 9/16/10 3:54 PM, Aras Angelo wrote:
>
>> Hello All
>>
>> I have a column in my table which is incrementally updated.
>>
>
> Try to give us more details...
>
Hello All
I have a column in my table which is incrementally updated. I cant set this
field to be a SERIAL because the value is not assigned at the time of the
INSERT, it is assigned later by the system by an UPDATE.
Whats the best way to achieve this by means of performance? Should i set the
MAX
upgrade to a gbps port and we will see how
this will effect.
On Tue, Oct 6, 2009 at 9:28 AM, Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> Aras Angelo wrote:
>
>> ...
>> When i kill the earliest idle process the others stop too. So i dont know
>> whats wron
is not doing good, and it only
effects us at peak times, so just wondering if killing processes every 2-3
minutes, would do harm on our setup.
I have 3 apache servers reading from one single db server.
On Mon, Oct 5, 2009 at 4:48 PM, Scott Marlowe wrote:
> On Mon, Oct 5, 2009 at 4:42 PM, A
Hi,
Im seeing lots of idle connections (not idle in transaction) to my database
server. My front end is written with PHP and i couldnt find anything that
can cause this. If i do a kill proc-id every few minutes on my server via
cron, would this effect anything badly?
Thanks
Sorry i forgot to mention it, max cli setting is 500.
On Tue, Sep 29, 2009 at 12:07 PM, wrote:
> Zitat von Aras Angelo :
>
> I have this server, Dual Intel Xeon 2.83GHz w 4gb ram.
>> My shared buffers were set to 1756 MB.
>>
>> We have a high traffic e-commerce
I have this server, Dual Intel Xeon 2.83GHz w 4gb ram.
My shared buffers were set to 1756 MB.
We have a high traffic e-commerce site, yesterday like 8 uniques.
We cache most of our dynamic pages to disk so its wierd we are experience
really slow response times with postgresql.
Usually the num
UPDATE table SET column=REPLACE(column,'@cc.edu','@somethingelse.com');
change "column" to field name respectively.
On Tue, Sep 8, 2009 at 10:46 AM, Marc Fromm wrote:
> I have a column that contains user email addresses. I need to update all
> email address in the column that end with @cc.edu
Im trying to alter a column type from character varying(8) to int.
All the values in the column are numbers but im getting this message
column "xx" cannot be cast to type integer
Dropping and readding the column is an option but downtime is very critical
to us, so i was wondering
if im doing
Hi All,
I recently upgraded my box to the latest version. The previous one was a
bit outdated. Apparently we have some bad structure formatting in our db
design, cause the latest version broke our software. The issue is some
character varying fields are used in queries joining to integers. The ol
gmake install requires root privileges.
It wont install with regular httpd user (apache, nobody etc.) on a php-shell
script or php system command functions.
On Mon, Nov 10, 2008 at 10:08 AM, Thomas Pundt <[EMAIL PROTECTED]> wrote:
> Scott Marlowe schrieb:
>
>> On Mon, Nov 10, 2008 at 8:50 AM, Da
Hello All,
I am getting this error while trying to install Skytools
pg_config: invalid argument: --pgxs
Running PgSQL 8.1.4
Isnt this method supported for my version?
Thanks
Angelo
stigate it, cause it spikes up so fast and
if we dont kill the postgres, it goes up to a load of 200 easily.
Any ideas what may be causing this?
Thank you for your replies
Aras Angelo
14 matches
Mail list logo
