pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPlease help me....
12+ messages / 9 participants
[nested] [flat]
* Please help me....
@ 2001-05-22 13:19 waheed rahman <waheed_rahuman@yahoo.com>
0 siblings, 0 replies; 12+ messages in thread
From: waheed rahman @ 2001-05-22 13:19 UTC (permalink / raw)
To: pgsql-admin; pgsql-sql-owner@postgresql.org; pgsql-sql@postgresql.org
Dear Sir,
I am waheed from dubai.
I got your mailid, when i am searching for a document
in postgresql.And your document helped me
alot and i some more doubts i hope you can help me.
This is my problem.
I am having a table called FRUITS which will be
updated by the merchants frequently as
the merchants got with them FRUITS.
At the same time my another web interface, have an
option for the public search to
the FRUITS.In this my educational project,if the
search result nothing
(query does not matches with the fruit detail).
I am having an option for the end user (ie) people who
searching for FRUITS can
register with their email ids and i will save their
specification of FRUITS(query for the
particular not avialable FRUIT).
So that when i got a new record in the table FRUITS,i
have to check for the query that i have
saved and if the query matches with new record added.I
have to send this FRUITS details to
that particular email id.
Please help me in this regard .I am expecting your
valuable reply.
How i can trigger email when the query matches.I am
using JSP for the complete web interface and
database is Postgres in my Red hat linux 7.0.I will be
thankfull for your valuable reply.
with warm regards and advance thankings from
waheed.
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
^ permalink raw reply [nested|flat] 12+ messages in thread
* Please help me
@ 2001-07-19 05:55 Mihai Afteni <mafteni@bizein.com>
2001-07-20 21:13 ` Re: Please help me Oleg Bartunov <oleg@sai.msu.su>
0 siblings, 1 reply; 12+ messages in thread
From: Mihai Afteni @ 2001-07-19 05:55 UTC (permalink / raw)
To: pgsql-admin
I have to provide a hardware-software configuration based on a PG
database,
capable to support min 500 simultaneous users each one accesing pages
that
send an average 6 queries per page. Minimum display time of any page = 5
second.
I have no precise idea about how such a configuration will be. An
estimate based on intuition: a dual (extensible to quad) processor Intel
computer with 1GB RAM and a min 30GB HDD 7200rpm. But intuition is not
an argument
Thank you in advance and all the best,
Mike
________________________________________________________________
Mihai AFTENI E-mail: mafteni @ bizein.com
general manager, partner mobile: Int + 40 93 23 77 10
EXPRESS INTEGRATOR SRL Developer and owner of
http://www.bizein.com Smart B2B Portal where you can
BUY, SELL, INVENT, ADVERTIZE, BID, OFFER
DESIGN, PROJECT, INVEST, LEARN, etc.
Bucharest, ROMANIA Tel/fax: Int + 40 1 420 58 54
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Please help me
2001-07-19 05:55 Please help me Mihai Afteni <mafteni@bizein.com>
@ 2001-07-20 21:13 ` Oleg Bartunov <oleg@sai.msu.su>
0 siblings, 0 replies; 12+ messages in thread
From: Oleg Bartunov @ 2001-07-20 21:13 UTC (permalink / raw)
To: Mihai Afteni <mafteni@bizein.com>; +Cc: pgsql-admin
Do you plan to use http for your service ?
If so, I'd recommend to use following architecture:
FE - proxy server is serving incoming requests and provides
results to client. It could be very light http server with proxy support.
BE - cgi-backend which receive proxied requests, contact with database
and returning results to proxy
DB - database which usually located at separate machine.
A reason for this architecture is optimizing of resources. We have
implemented this scheme in many projects and it's really works,
see for example fts.postgresql.org.
Also, I'd recommend to setup separate http server for serving
static images like logos, icons etc. We use thttpd (http://www.acme.com)
which is very fast and lightweight.
You'd keep persistent connection BE-DB to save connection time which
is rather big for postgresql.
Using calculator, know memory required for each component
(FE,BE,DB), average time for request you could get some numbers for
your hardware. There are many hints, so if you are from perl world,
I'd recommend to read excellent mod_perl guide by Stas Beckman
http://perl.apache.org/guide
You should run several experiments to optimize your servers and get
real numbers for memory footprints. For example it's very important
to provide enough memory for database backend (shared memory, sort buffers),
so your queries would processed faster.
Regards,
Oleg
On Thu, 19 Jul 2001, Mihai Afteni wrote:
> I have to provide a hardware-software configuration based on a PG
> database,
> capable to support min 500 simultaneous users each one accesing pages
> that
> send an average 6 queries per page. Minimum display time of any page = 5
> second.
>
> I have no precise idea about how such a configuration will be. An
> estimate based on intuition: a dual (extensible to quad) processor Intel
> computer with 1GB RAM and a min 30GB HDD 7200rpm. But intuition is not
> an argument
>
> Thank you in advance and all the best,
>
> Mike
>
> ________________________________________________________________
> Mihai AFTENI E-mail: mafteni @ bizein.com
> general manager, partner mobile: Int + 40 93 23 77 10
> EXPRESS INTEGRATOR SRL Developer and owner of
> http://www.bizein.com Smart B2B Portal where you can
> BUY, SELL, INVENT, ADVERTIZE, BID, OFFER
> DESIGN, PROJECT, INVEST, LEARN, etc.
> Bucharest, ROMANIA Tel/fax: Int + 40 1 420 58 54
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
^ permalink raw reply [nested|flat] 12+ messages in thread
* Please Help me ????
@ 2003-05-30 04:08 utomo restu <utomo@linuxmail.org>
2003-05-30 15:02 ` Re: Please Help me ???? Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 1 reply; 12+ messages in thread
From: utomo restu @ 2003-05-30 04:08 UTC (permalink / raw)
To: pgsql-admin
Dear All
I'am a new user in postgresql, i want to ask about :
1. The one who is intended with STORED PROCEDURE,
how its implement and what its surplus.
Version POSTGRESQL that how much possess STRORED PROCEDURE.
2. In when I make the function as follows:
CREATE FUNCTION forward(CHAR(10))
RETURNS CHAR(10), CHAR(30)
AS 'select no_id, name FROM address where no_id=$1;'
Language 'sql';
To step forward orders the error ...
Which wants I asked, how make a function that can step forward RETURNS More than a column
(I want to show 2 columns i.e. no_id and Name) ?
thank's
--
______________________________________________
http://www.linuxmail.org/
Now with e-mail forwarding for only US$5.95/yr
Powered by Outblaze
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Please Help me ????
2003-05-30 04:08 Please Help me ???? utomo restu <utomo@linuxmail.org>
@ 2003-05-30 15:02 ` Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 0 replies; 12+ messages in thread
From: Robert Treat @ 2003-05-30 15:02 UTC (permalink / raw)
To: utomo restu <utomo@linuxmail.org>; +Cc: pgsql-admin
First, make sure your running on a version of 7.3, then check out the
following docs:
http://techdocs.postgresql.org/guides/SetReturningFunctions
http://www.gtsm.com/cgi/psearch?page=plpgsql.html;q=plpgsql;j=0;c=0;h=0
Robert Treat
On Fri, 2003-05-30 at 00:08, utomo restu wrote:
>
> Dear All
>
> I'am a new user in postgresql, i want to ask about :
>
> 1. The one who is intended with STORED PROCEDURE,
> how its implement and what its surplus.
> Version POSTGRESQL that how much possess STRORED PROCEDURE.
>
> 2. In when I make the function as follows:
>
> CREATE FUNCTION forward(CHAR(10))
> RETURNS CHAR(10), CHAR(30)
> AS 'select no_id, name FROM address where no_id=$1;'
> Language 'sql';
>
> To step forward orders the error ...
> Which wants I asked, how make a function that can step forward RETURNS More than a column
> (I want to show 2 columns i.e. no_id and Name) ?
>
> thank's
> --
> ______________________________________________
> http://www.linuxmail.org/
> Now with e-mail forwarding for only US$5.95/yr
>
> Powered by Outblaze
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
^ permalink raw reply [nested|flat] 12+ messages in thread
* Please Help me ???
@ 2003-09-19 13:54 utomo restu <utomo@linuxmail.org>
0 siblings, 0 replies; 12+ messages in thread
From: utomo restu @ 2003-09-19 13:54 UTC (permalink / raw)
To: pgsql-admin
To all,
I want to ask some questions:
1. I want to changes the posisions of postgres super user with my user, so
my user have a function same with postgres super user
(I want only one super user in my database).
so if i do it, what happens on my database...??????
2.How i now total of row and column from array.
example, if total of row is 6 and column is 4.
how the sql syntax...?????
3. How i create function with array parameter (type array) ???
example:
in database postgresql i was create function with array parameter
my_array[] --> this syntax success.
but when the array parameter is my_array[][], the result ERROR.
why....????
Thank's for the answer's
regards
Utomo
--
______________________________________________
http://www.linuxmail.org/
Now with e-mail forwarding for only US$5.95/yr
Powered by Outblaze
^ permalink raw reply [nested|flat] 12+ messages in thread
* please help me
@ 2010-08-27 16:07 pavankumar reddy <pavankumar.csn@gmail.com>
2010-08-27 16:27 ` Re: please help me Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 12+ messages in thread
From: pavankumar reddy @ 2010-08-27 16:07 UTC (permalink / raw)
To: pgsql-admin
HELLO ,
This is pavankumar , working on postgresql 8.1.4, database, for
which iam new and very less in knowledge. Iam not an expert.
please help me in resolving the problem which iam facing since one week.the
problem is
1)IAM UNABLE TO TAKE A COMPLETE BACKUP OF DATABASE
2)IAM UNABLE TO QUERY THE FULL DATA IN A PARTICULAR TABLE(where the database
backup is stoping) giving an error like missing chunk number 0 for toast
value XXXXXX
3)IAM UNABLE TO RESOLVE THIS PROBLEM.
DATABASE: postgresql 8.1.4(also using pgadmin from remote system)
OPERATING SYSTEM: redhat enterprise linux 5 ON DELL POWER EDGE 2950
********database is stored on a gnbd .
THANKS IN ADVANCE
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: please help me
2010-08-27 16:07 please help me pavankumar reddy <pavankumar.csn@gmail.com>
@ 2010-08-27 16:27 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 12+ messages in thread
From: Kevin Grittner @ 2010-08-27 16:27 UTC (permalink / raw)
To: pavankumar reddy <pavankumar.csn@gmail.com>; pgsql-admin
pavankumar reddy <pavankumar.csn@gmail.com> wrote:
> working on postgresql 8.1.4
You need to at least get onto an 8.1 revision which is more recent.
You're missing over four years of bug fixes.
http://www.postgresql.org/support/versioning
http://www.postgresql.org/docs/8.1/static/release.html
> 1)IAM UNABLE TO TAKE A COMPLETE BACKUP OF DATABASE
How are you attempting to make the backup? What happens when you
try?
> 2)IAM UNABLE TO QUERY THE FULL DATA IN A PARTICULAR TABLE(where
> the database backup is stoping) giving an error like missing chunk
> number 0 for toast value XXXXXX
Copy and paste is better than paraphrasing.
Please use capital letters more sparingly, and please read this
before your next post:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
It should help guide you to posting the information people need in
order to be more helpful.
From what you've posted so far, it appears that you have a database
corruption, so I feel safe in saying that your next step should be
to stop the database service and copy the entire data directory
tree. Save this until you've been running without problems for a
few weeks or months.
-Kevin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Please Help Me...
@ 2014-02-26 08:48 Rafiqul Haque <rafiq.ced@gmail.com>
2014-02-26 08:57 ` Re: Please Help Me... Ian Lawrence Barwick <barwick@gmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: Rafiqul Haque @ 2014-02-26 08:48 UTC (permalink / raw)
To: pgsql-admin
Hi,
I am confronting this error (I pasted below). It gives a hint to increase
"You might need to increase max_locks_per_transaction" which I did but get
the same error .... please please suggest me something to get rid of this
error.. I would really be grateful..
My script create 13000 empty tables. Each table contains 130 attributes...
My server has 8 GB RAM 64 bit processor, running windows 7 OS
Best regards,
Rafiq
********************************* *Error*
***********************************************************************************************************************
WARNING: out of shared memory
CONTEXT: SQL statement "CREATE TABLE table3691 (cust_id
integer,archiveexpiration date,archivedatetime timestamp,archivepurge
date,cancelrequestdatetime timestamp,
sndaddress TEXT,sndtype TEXT,rcpcompany TEXT,rcpname TEXT,sndaccount
TEXT,sndcompany TEXT,sndname TEXT,
sub_date_time timestamp,acc_date_time timestamp,senddatetime
timestamp,conv_date_time timestamp,
comp_date_time timestamp,call_cost integer,totalcallcost
integer,valid_date_time timestamp,
lstry_date_time timestamp,ntry_date_time timestamp,deferred_c integer,state
integer,dist_lastwrite timestamp,
dist_num integer,dist_version integer,dist_owner_date_time
timestamp,dist_aborted integer,dist_abortedcount integer,
contflag integer,statuscode integer,previewmessage integer,previewvisible
integer,status_str text,max_rtry integer,
n_tries integer,msn integer,deleted integer,subjet text,archiveduration
integer,priority integer,def_date_time timestamp,
ident text,estimprice integer,estimpriceunit integer,realprice
integer,realpriceunit integer,contractid text,mainaccountid text,
processinglabel text,viewed integer,notif integer,notifindex integer,purged
integer,arcmsn integer,arstate integer,arcsavfile text,
prgf_date_time timestamp,prgr_date_time timestamp,remotemsn
integer,delegatedsend integer,delegatedcancelled integer,
delegationsyncid text,delegatesyncid text,remotenetworkport
integer,remotenetworkprotocol text,
vld_date_time timestamp,valid_ownerid text,validationstate text,ownerpb
text,srcruid text,originaljobid text,resultflowid text,workflowid text,
usercomment text,n_pages integer,page_produced integer,pages_sent
integer,groupkey text,isbillable text,retrievedbyclient
text,billing_summary text,parentprocessid text,processid text,rcv_date_time
timestamp,forceupdatecount integer,forwardsuccess integer,forwarfailed
integer,forwardcancelled integer,forwarderror
integer,forwardvalidationopending integer,needvalid integer,preferredvalid
text,sendtype text,srcfilename text,al_templateinstance
integer,al_templateinstancepostcover integer,al_numpage
integer,al_numpagepostcover integer,
al_distance integer,vldor_date_time timestamp,validor_ownerid
text,validor_cookie text,appname text,nbheaderfields integer,nbtablefields
integer,ootoenable integer,warning_date_time timestamp,denyquickvalidation
integer,docid text,department text,flowid text,satid text,lbserver
text,dist_file integer,writablewhencomplete integer,donotpurge
integer,lastsaved_date_time timestamp,lastsaved_ownerid text,
lastsaved_ownerpd text,autolearning timestamp,coverpagecount integer,split
integer,splitdone integer,splitdocumentcount integer,splitdocumentnumber
integer,touchless integer,
touchlessdone integer,flattenannotations integer,flattencomment
integer,toto text,supplementaryrule text,iscclose
integer,statusonexpiration integer,waitingforupdate integer,
from_ownerid text,originalfrom_ownerid text)"
PL/pgSQL function table_data(integer,integer,integer) line 34 at EXECUTE
statement
ERROR: out of shared memory
HINT: You might need to increase max_locks_per_transaction.
CONTEXT: SQL statement "CREATE TABLE table3691 (cust_id
integer,archiveexpiration date,archivedatetime timestamp,archivepurge
date,cancelrequestdatetime timestamp,
sndaddress TEXT,sndtype TEXT,rcpcompany TEXT,rcpname TEXT,sndaccount
TEXT,sndcompany TEXT,sndname TEXT,
sub_date_time timestamp,acc_date_time timestamp,senddatetime
timestamp,conv_date_time timestamp,
comp_date_time timestamp,call_cost integer,totalcallcost
integer,valid_date_time timestamp,
lstry_date_time timestamp,ntry_date_time timestamp,deferred_c integer,state
integer,dist_lastwrite timestamp,
dist_num integer,dist_version integer,dist_owner_date_time
timestamp,dist_aborted integer,dist_abortedcount integer,
contflag integer,statuscode integer,previewmessage integer,previewvisible
integer,status_str text,max_rtry integer,
n_tries integer,msn integer,deleted integer,subjet text,archiveduration
integer,priority integer,def_date_time timestamp,
ident text,estimprice integer,estimpriceunit integer,realprice
integer,realpriceunit integer,contractid text,mainaccountid text,
processinglabel text,viewed integer,notif integer,notifindex integer,purged
integer,arcmsn integer,arstate integer,arcsavfile text,
prgf_date_time timestamp,prgr_date_time timestamp,remotemsn
integer,delegatedsend integer,delegatedcancelled integer,
delegationsyncid text,delegatesyncid text,remotenetworkport
integer,remotenetworkprotocol text,
vld_date_time timestamp,valid_ownerid text,validationstate text,ownerpb
text,srcruid text,originaljobid text,resultflowid text,workflowid text,
usercomment text,n_pages integer,page_produced integer,pages_sent
integer,groupkey text,isbillable text,retrievedbyclient
text,billing_summary text,parentprocessid text,processid text,rcv_date_time
timestamp,forceupdatecount integer,forwardsuccess integer,forwarfailed
integer,forwardcancelled integer,forwarderror
integer,forwardvalidationopending integer,needvalid integer,preferredvalid
text,sendtype text,srcfilename text,al_templateinstance
integer,al_templateinstancepostcover integer,al_numpage
integer,al_numpagepostcover integer,
al_distance integer,vldor_date_time timestamp,validor_ownerid
text,validor_cookie text,appname text,nbheaderfields integer,nbtablefields
integer,ootoenable integer,warning_date_time timestamp,denyquickvalidation
integer,docid text,department text,flowid text,satid text,lbserver
text,dist_file integer,writablewhencomplete integer,donotpurge
integer,lastsaved_date_time timestamp,lastsaved_ownerid text,
lastsaved_ownerpd text,autolearning timestamp,coverpagecount integer,split
integer,splitdone integer,splitdocumentcount integer,splitdocumentnumber
integer,touchless integer,
touchlessdone integer,flattenannotations integer,flattencomment
integer,toto text,supplementaryrule text,iscclose
integer,statusonexpiration integer,waitingforupdate integer,
from_ownerid text,originalfrom_ownerid text)"
PL/pgSQL function table_data(integer,integer,integer) line 34 at EXECUTE
statement
********** Error **********
ERROR: out of shared memory
SQL state: 53200
Hint: You might need to increase max_locks_per_transaction.
Context: SQL statement "CREATE TABLE table3691 (cust_id
integer,archiveexpiration date,archivedatetime timestamp,archivepurge
date,cancelrequestdatetime timestamp,
sndaddress TEXT,sndtype TEXT,rcpcompany TEXT,rcpname TEXT,sndaccount
TEXT,sndcompany TEXT,sndname TEXT,
sub_date_time timestamp,acc_date_time timestamp,senddatetime
timestamp,conv_date_time timestamp,
comp_date_time timestamp,call_cost integer,totalcallcost
integer,valid_date_time timestamp,
lstry_date_time timestamp,ntry_date_time timestamp,deferred_c integer,state
integer,dist_lastwrite timestamp,
dist_num integer,dist_version integer,dist_owner_date_time
timestamp,dist_aborted integer,dist_abortedcount integer,
contflag integer,statuscode integer,previewmessage integer,previewvisible
integer,status_str text,max_rtry integer,
n_tries integer,msn integer,deleted integer,subjet text,archiveduration
integer,priority integer,def_date_time timestamp,
ident text,estimprice integer,estimpriceunit integer,realprice
integer,realpriceunit integer,contractid text,mainaccountid text,
processinglabel text,viewed integer,notif integer,notifindex integer,purged
integer,arcmsn integer,arstate integer,arcsavfile text,
prgf_date_time timestamp,prgr_date_time timestamp,remotemsn
integer,delegatedsend integer,delegatedcancelled integer,
delegationsyncid text,delegatesyncid text,remotenetworkport
integer,remotenetworkprotocol text,
vld_date_time timestamp,valid_ownerid text,validationstate text,ownerpb
text,srcruid text,originaljobid text,resultflowid text,workflowid text,
usercomment text,n_pages integer,page_produced integer,pages_sent
integer,groupkey text,isbillable text,retrievedbyclient
text,billing_summary text,parentprocessid text,processid text,rcv_date_time
timestamp,forceupdatecount integer,forwardsuccess integer,forwarfailed
integer,forwardcancelled integer,forwarderror
integer,forwardvalidationopending integer,needvalid integer,preferredvalid
text,sendtype text,srcfilename text,al_templateinstance
integer,al_templateinstancepostcover integer,al_numpage
integer,al_numpagepostcover integer,
al_distance integer,vldor_date_time timestamp,validor_ownerid
text,validor_cookie text,appname text,nbheaderfields integer,nbtablefields
integer,ootoenable integer,warning_date_time timestamp,denyquickvalidation
integer,docid text,department text,flowid text,satid text,lbserver
text,dist_file integer,writablewhencomplete integer,donotpurge
integer,lastsaved_date_time timestamp,lastsaved_ownerid text,
lastsaved_ownerpd text,autolearning timestamp,coverpagecount integer,split
integer,splitdone integer,splitdocumentcount integer,splitdocumentnumber
integer,touchless integer,
touchlessdone integer,flattenannotations integer,flattencomment
integer,toto text,supplementaryrule text,iscclose
integer,statusonexpiration integer,waitingforupdate integer,
from_ownerid text,originalfrom_ownerid text)"
PL/pgSQL function table_data(integer,integer,integer) line 34 at EXECUTE
statement
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Please Help Me...
2014-02-26 08:48 Please Help Me... Rafiqul Haque <rafiq.ced@gmail.com>
@ 2014-02-26 08:57 ` Ian Lawrence Barwick <barwick@gmail.com>
2014-02-26 11:20 ` Re: Please Help Me... Ian Lawrence Barwick <barwick@gmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: Ian Lawrence Barwick @ 2014-02-26 08:57 UTC (permalink / raw)
To: Rafiqul Haque <rafiq.ced@gmail.com>; +Cc: pgsql-admin
2014-02-26 17:48 GMT+09:00 Rafiqul Haque <rafiq.ced@gmail.com>:
> Hi,
>
> I am confronting this error (I pasted below). It gives a hint to increase
> "You might need to increase max_locks_per_transaction" which I did but get
> the same error .... please please suggest me something to get rid of this
> error.. I would really be grateful..
>
> My script create 13000 empty tables. Each table contains 130 attributes...
>
> My server has 8 GB RAM 64 bit processor, running windows 7 OS
>
> Best regards,
> Rafiq
>
>
> *********************************
> Error***********************************************************************************************************************
>
> WARNING: out of shared memory
What is your server's shared_buffers setting? And which version of PostgreSQL
are you using? I.e. output of these statements:
SHOW shared_buffers;
SELECT version();
Regards
Ian Barwick
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Please Help Me...
2014-02-26 08:48 Please Help Me... Rafiqul Haque <rafiq.ced@gmail.com>
2014-02-26 08:57 ` Re: Please Help Me... Ian Lawrence Barwick <barwick@gmail.com>
@ 2014-02-26 11:20 ` Ian Lawrence Barwick <barwick@gmail.com>
2014-02-26 11:41 ` Re: Please Help Me... Ian Lawrence Barwick <barwick@gmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: Ian Lawrence Barwick @ 2014-02-26 11:20 UTC (permalink / raw)
To: Rafiqul Haque <rafiq.ced@gmail.com>; +Cc: pgsql-admin
2014-02-26 19:39 GMT+09:00 Rafiqul Haque <rafiq.ced@gmail.com>:
> Hi,
>
> Thanks very much for prompt response. I executed the commands you suggested.
Please don't forget to CC the original mailing list, because more people will
be able to help you.
> Shared buffer is 128MB (I did know that, I thought it is taking all my GB
> automatically !!!!)
>
> The version is 9.3.2
128MB is the default setting for shared_buffers and is very low.
You'll need to adjust
that and some other settings (especially work_mem and maintenance_work_mem)
appropriately for your system. See e.g.:
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
Regards
Ian Barwick
> Cheers,
>
>
> On Wed, Feb 26, 2014 at 9:57 AM, Ian Lawrence Barwick <barwick@gmail.com>
> wrote:
>>
>> 2014-02-26 17:48 GMT+09:00 Rafiqul Haque <rafiq.ced@gmail.com>:
>> > Hi,
>> >
>> > I am confronting this error (I pasted below). It gives a hint to
>> > increase
>> > "You might need to increase max_locks_per_transaction" which I did but
>> > get
>> > the same error .... please please suggest me something to get rid of
>> > this
>> > error.. I would really be grateful..
>> >
>> > My script create 13000 empty tables. Each table contains 130
>> > attributes...
>> >
>> > My server has 8 GB RAM 64 bit processor, running windows 7 OS
>> >
>> > Best regards,
>> > Rafiq
>> >
>> >
>> > *********************************
>> >
>> > Error***********************************************************************************************************************
>> >
>> > WARNING: out of shared memory
>>
>> What is your server's shared_buffers setting? And which version of
>> PostgreSQL
>> are you using? I.e. output of these statements:
>>
>> SHOW shared_buffers;
>> SELECT version();
>>
>> Regards
>>
>> Ian Barwick
>
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Please Help Me...
2014-02-26 08:48 Please Help Me... Rafiqul Haque <rafiq.ced@gmail.com>
2014-02-26 08:57 ` Re: Please Help Me... Ian Lawrence Barwick <barwick@gmail.com>
2014-02-26 11:20 ` Re: Please Help Me... Ian Lawrence Barwick <barwick@gmail.com>
@ 2014-02-26 11:41 ` Ian Lawrence Barwick <barwick@gmail.com>
0 siblings, 0 replies; 12+ messages in thread
From: Ian Lawrence Barwick @ 2014-02-26 11:41 UTC (permalink / raw)
To: Rafiqul Haque <rafiq.ced@gmail.com>; +Cc: pgsql-admin
2014-02-26 20:35 GMT+09:00 Rafiqul Haque <rafiq.ced@gmail.com>:
> Thanks a lot Ian.. I figured out that as well... I am trying to figure out
> how many tables my server can create …
Why not try for a billion?
http://www.pgcon.org/2013/schedule/events/595.en.html
;)
Regards
Ian Barwick
>
> On Wed, Feb 26, 2014 at 12:20 PM, Ian Lawrence Barwick <barwick@gmail.com>
> wrote:
>>
>> 2014-02-26 19:39 GMT+09:00 Rafiqul Haque <rafiq.ced@gmail.com>:
>> > Hi,
>> >
>> > Thanks very much for prompt response. I executed the commands you
>> > suggested.
>>
>> Please don't forget to CC the original mailing list, because more people
>> will
>> be able to help you.
>>
>> > Shared buffer is 128MB (I did know that, I thought it is taking all my
>> > GB
>> > automatically !!!!)
>> >
>> > The version is 9.3.2
>>
>> 128MB is the default setting for shared_buffers and is very low.
>> You'll need to adjust
>> that and some other settings (especially work_mem and
>> maintenance_work_mem)
>> appropriately for your system. See e.g.:
>>
>> http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
>>
>> Regards
>>
>> Ian Barwick
>>
>>
>>
>> > Cheers,
>> >
>> >
>> > On Wed, Feb 26, 2014 at 9:57 AM, Ian Lawrence Barwick
>> > <barwick@gmail.com>
>> > wrote:
>> >>
>> >> 2014-02-26 17:48 GMT+09:00 Rafiqul Haque <rafiq.ced@gmail.com>:
>> >> > Hi,
>> >> >
>> >> > I am confronting this error (I pasted below). It gives a hint to
>> >> > increase
>> >> > "You might need to increase max_locks_per_transaction" which I did
>> >> > but
>> >> > get
>> >> > the same error .... please please suggest me something to get rid of
>> >> > this
>> >> > error.. I would really be grateful..
>> >> >
>> >> > My script create 13000 empty tables. Each table contains 130
>> >> > attributes...
>> >> >
>> >> > My server has 8 GB RAM 64 bit processor, running windows 7 OS
>> >> >
>> >> > Best regards,
>> >> > Rafiq
>> >> >
>> >> >
>> >> > *********************************
>> >> >
>> >> >
>> >> > Error***********************************************************************************************************************
>> >> >
>> >> > WARNING: out of shared memory
>> >>
>> >> What is your server's shared_buffers setting? And which version of
>> >> PostgreSQL
>> >> are you using? I.e. output of these statements:
>> >>
>> >> SHOW shared_buffers;
>> >> SELECT version();
>> >>
>> >> Regards
>> >>
>> >> Ian Barwick
>> >
>> >
>
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2014-02-26 11:41 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-22 13:19 Please help me.... waheed rahman <waheed_rahuman@yahoo.com>
2001-07-19 05:55 Please help me Mihai Afteni <mafteni@bizein.com>
2001-07-20 21:13 ` Re: Please help me Oleg Bartunov <oleg@sai.msu.su>
2003-05-30 04:08 Please Help me ???? utomo restu <utomo@linuxmail.org>
2003-05-30 15:02 ` Re: Please Help me ???? Robert Treat <xzilla@users.sourceforge.net>
2003-09-19 13:54 Please Help me ??? utomo restu <utomo@linuxmail.org>
2010-08-27 16:07 please help me pavankumar reddy <pavankumar.csn@gmail.com>
2010-08-27 16:27 ` Re: please help me Kevin Grittner <Kevin.Grittner@wicourts.gov>
2014-02-26 08:48 Please Help Me... Rafiqul Haque <rafiq.ced@gmail.com>
2014-02-26 08:57 ` Re: Please Help Me... Ian Lawrence Barwick <barwick@gmail.com>
2014-02-26 11:20 ` Re: Please Help Me... Ian Lawrence Barwick <barwick@gmail.com>
2014-02-26 11:41 ` Re: Please Help Me... Ian Lawrence Barwick <barwick@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox