dexable with gist or spgist. I don't think the docs cover the actual
implementation internals though - you'll probably have to go to the source
if you need that.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
ith start/stop backups etc).
You can't upgrade the standbys and have them re-join the master, they have
to be redone from scratch.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
y id;
>
>
There is no "id" column in the returned dataset to order by. You are just
returning one value, how would it be ordered? (and that row has a column
named "count" - but you can alias it to SELECT count(distinct id) AS id
FROM bg ORDER BY id - it just makes no sense to order a single row..
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Jun 12, 2015 1:33 PM, "Albe Laurenz" wrote:
>
> Birta Levente wrote:
> > In the postgresql yum repo appeared the 9.3.9 and 9.4.4, but on the
> > postgresql.org nothing about the new version. Where I can see the
changelog?
>
> AFAIK, it is being packaged and will be announced soon.
The rpm pack
wouldn't accept a patch for that
functionality.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
hich make it
take time. Try with "-c fast" and see if the problem goes away.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Wed, Oct 5, 2016 at 3:55 PM, otheus uibk wrote:
>
>
> On Tue, Oct 4, 2016 at 10:49 PM, Magnus Hagander
> wrote:
>
>>
>>
>> On Tue, Oct 4, 2016 at 10:42 PM, otheus uibk
>> wrote:
>>
>>> After a 3 to 4 minute delay, pg_basebackup started
nly potential problem. If you are
willing to spend towards it, it would probably be better to spend towards
the "upper layer" problem which would be to make it possible to move
pg_largeobject to a different tablespace *without* turning on
system_table_mods.
That said, I cannot comment to the complexity of either doing that *or*
doing a custom pg_upgrade that would support it. But solving a long-term
problem seems better than solving a one-off one.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Nov 29, 2015 18:34, "George Neuner" wrote:
>
> On Sun, 29 Nov 2015 05:04:42 -0500, "Steve Petrie, P.Eng."
> wrote:
>
> >"George Neuner" wrote in message
> >news:kaed5btl92qr4v8ndevlgtv0f28qaae...@4ax.com...
> >
> >> My vote for an email client would be Thunderbird. It runs on XP or
> >> high
rom a libpq perspective ,the replication standby is "just
another client", so any parameters that work for libpq should work there.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Dec 21, 2015 08:58, "james garner" wrote:
>
> Dear list,
>
> i'm running PgSQL 9.3 on Debian installed from the Debian packets.
> I'm using dblink to access a different database.
> When im trying to connect to the database by socket via
> dblink_exec('dbname=test host=/var/run/postgresql' ..
>
suggested by others.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Fri, Jan 22, 2016 at 8:37 PM, David E. Wheeler
wrote:
> On Jan 22, 2016, at 11:28 AM, Magnus Hagander wrote:
>
> > Regardless whether it's true or not (to which I cannot speak), surely
> statements like that would violate *both* the contributor covenant *and*
> the
ago and doesn't actually exist
anymore.
(The advanced servers version does of course, but that's not open source).
I think the only "Plus" product now is their cloud offering?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Mar 2, 2016 06:01, "John R Pierce" wrote:
>
> (thread moved from pg_bugs)
> (upgrading a 8.0.13 database on Windows XP 32bit to 9.5.1 on Windows 8 64
bit.)
>
>
> On 3/1/2016 8:05 PM, Premsun Choltanwanich wrote:
>>
>> Modified command by remove -Ft flag as per you suggestion:
>> pg_dump -v
ral email, it doesn't have any shortcut) does not contain this address
naywhere, it was only used as an envelope sender. Possibly it got confused
by the other VERP address in the initial email, which AFAICT is a manual
mistake.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
0 (and it shows nothing).
>
That looks like a kernel issue/bug. Both because the log comes from the
kernel, and because PostgeSQL can't actually take down the whole PC as long
as the kernel is working properly.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Mar 22, 2016 6:14 PM, "Frits Jalvingh" wrote:
>
> Hello list,
>
> Oracle has a way to get per-session statistics. You identify a session
using a call to dbms_session.set_identifier('xxx'), then you enable
statistics using dbms_monitor.client_id_stat_enable('xxx').
> After this you do normal dat
ig issues we've had with ipv6 routing recently.
It should be back up now.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
Cyril VELTER wrote:
>
>>> Cyril VELTER wrote:
Searching the source files, it seems the error message is generated in
port/win32/socket.c line 594.
>>> Right, but the important thing is which path down to that function is it
>>> generated in. Which is why a backtrace would help.
>>
Cyril VELTER wrote:
> OK, I've the results of my tests :
>
> With the previous code, then message "SOCKERROR" is printed 5 times
> during the
> whole process (100 Gb dump import with psql). There one group of three and
> one
> group of two, but I don't have timestamps and am not su
On Tue, May 29, 2007 at 11:25:30PM +0200, Magnus Hagander wrote:
> > What do you think ? may be a bug in the windows server installation I
> > have
> > (this machines have not been updated for some times, perhaps I should try
> > to do
> > that and see if the
Robert Fitzpatrick wrote:
> Can anyone suggest how one might be able to do this? I want to be able
> to generate an 8 character random password for users in their password
> field. Perhaps through the default setting of the field or a trigger
> function. I found the following, but is there anything
On Mon, Jun 11, 2007 at 10:44:38AM -0700, Gabriele wrote:
> I'm going to develop a medium sized business desktop client server
> application which will be deployed mostly on small sized networks and
> later eventually, hopefully, on medium sized networks.
> It will probably be developed using C#.
>
On Wed, Jun 20, 2007 at 10:17:10AM +0900, EBIHARA, Yuichiro wrote:
> Hi,
>
> Can I get a PostgreSQL Installer for Windows x64(EM64T)?
> That for 32bit Windows is available at http://www.postgresql.org/ftp/win32/
> but I need x64 native
> version.
There is no such thing. PostgreSQL 64-bit is curr
On Wed, Jun 20, 2007 at 04:31:40PM +0900, EBIHARA, Yuichiro wrote:
> Magnus,
>
> Thank you for your quick reply.
>
> > > Can I get a PostgreSQL Installer for Windows x64(EM64T)?
> > > That for 32bit Windows is available at
> > > http://www.postgresql.org/ftp/win32/ but I need x64 native version.
Naz Gassiep wrote:
> Hey,
> I'm sure that'd be greatly appreciated, most other major servers and
> DBs have a similar feature, and that's what the systray is for, i.e.,
> viewing major user-installed services.
Don't forget that the tray (or taskbar notification area as it's
supposed to be call
Tony Caduto wrote:
> Bruce Momjian wrote:
>> Naz Gassiep wrote:
>>
>>> I'm using PG on windows for the first time (as of about 6 minutes ago).
>>> I was thinking that it would be great to have a system tray icon with a
>>> running indicator, kind of like the way Apache2.x for windows has, or
>>>
Joris Dobbelsteen wrote:
>> -Original Message-
>> From: [EMAIL PROTECTED]
>> [mailto:[EMAIL PROTECTED] On Behalf Of
>> Magnus Hagander
>> Sent: zaterdag 23 juni 2007 11:39
>> To: Naz Gassiep
>> Cc: Tony Caduto; pgsql-general@postgresql.org
Jason Long wrote:
> I have a client that wants a disaster recovery plan put into place.
> What is the easiest way to do a hands free install of postgresql on a
> window box?
http://pginstaller.projects.postgresql.org/silent.html
//Magnus
---(end of broadcast)---
Mavinakuli, Prasanna (STSD) wrote:
> Hello All,
>
> We are looking for your help.The scenarion which we need to address
> is,There are 2 threads and both of them are in separate transction and
> insert the value to a same table and also sequence number field gets
> incremented automotically for ea
Pouria wrote:
> Hi,
>
> When I try to install pljava 1.3 on postgresql 8.2 (or 8.1) I get an
> error stating that it cannot load pljava.dll from a location
> specificed in the config file (while the dll is clearly there). I have
> followed the postgredql and pljava manual installation instructions
siva prakash wrote:
> if i run the setup choose language then go to next button it shows error
> *"Failed to create process: 2!*
Please don't remove the mailinglist from the CC list, so others can
learn from the answers.
The error you get indicates that your windows installation is broken. At
tha
Dave Page wrote:
>
>> siva prakash wrote:
>>> if i run the setup choose language then go to next button it shows error
>>> *"Failed to create process: 2!*
>> Please don't remove the mailinglist from the CC list, so others can
>> learn from the answers.
>>
>> The error you get indicates that your w
On Sun, Jul 01, 2007 at 10:46:22PM -0300, Jorge Godoy wrote:
> On Sunday 01 July 2007 22:25:24 Casey Crosbie wrote:
> > Jorge,
> >
> > Thanks for the suggestion. But unfortunately, I tried both
> > \cd "C:/Document~1" and just \cd C:/"Document~1" and neither worked.
>
> Sorry. It should be up t
On Tue, Jul 10, 2007 at 04:34:56PM +0530, Ashish Karalkar wrote:
> >>Hello All,
> >>
> >>I am trying tu run a script to create database from a batch programme
> >>and dont want to supply password everytime.
> >>So i tried to setup pgpass.conf file.
> >>File is kept in user profile/application data
On Thu, Jul 19, 2007 at 10:41:03AM -0400, Tom Lane wrote:
> Luca Ferrari <[EMAIL PROTECTED]> writes:
> > I'd like to better understand how the optimizer works and is implemented.
> > Is
> > there any available documentation (before start reading the source!) to
> > understand concepts about geqo
On Fri, Jul 20, 2007 at 09:24:05AM +0200, Zlatko Matić wrote:
> Hi.
> If I understood correctly, this blog describes how to create second instance
> that is linked to first (the same service acount user)?
> But, I want to know whether it is possible to have second instance completely
> independen
Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
>> On Thu, Jul 19, 2007 at 10:41:03AM -0400, Tom Lane wrote:
>>> The developers section of the website used to have slides from a couple
>>> of talks I gave at OSCON, but I don't see them there a
Joe L wrote:
> Hi,
>
> I saw the page on silent installation of postgres, but I want to be able
> to uninstall postgres when my product is uninstalled, silently. I
> couldn't find the product ID anywhere, which is the method I'm using for
> uninstalling the JRE.
>
> Any help on how to uninstall
On Wed, Jul 25, 2007 at 09:08:56PM -0700, Robby Russell wrote:
> Hey all,
>
> I'm catching up the replication options for PostgreSQL and was looking
> at slony, but was wondering if I could get some pointers.
>
> If I understand the slony documentation correctly, it doesn't allow me
> to send C
Mitchell Vincent wrote:
> Now that I think of it, shouldn't everything that is needed to build
> the .MSI installer be in one of the source packages? As a user of
> InnoSetup I'm afraid I'm clueless about MSI, so if someone could shove
> me in the right direction I'd sure appreciate it!
All that's
Mitchell Vincent wrote:
> Ah, I see what you mean.
>
> I was hoping to be able to rebuild the MSI to not include the things I
> didn't need but that doesn't look like it's going to be the case
> Humbug.. Is there any way at all to modify what's contained in the MSI
> file so I can shrink the d
Tony Caduto wrote:
> Andrei Kovalevski wrote:
>>Hi all!
>>
>>Everyone who use PostgreSQL server on Windows knows - it would be
>> nice to have some tray management and monitoring tool for PostgreSQL
>> server which is running as NT Service (for example - MS SQL already
>> have such tool).
Andrei Kovalevski wrote:
>> Have you done any development yet?
> Yes, you can download and try it. Now it's a single pgtray.exe
> application. I'm going to make an msi installer and add "Autostart"
> option to the menu.
When you do the installer, please make sure it's compatible with
stackbuilder
nac1967 wrote:
> I am a PostgreSQL user, using the native windows version 8.2. I am new
> to PostgreSQL and am wondering if other users have suggestions
> regarding command line interfaces. I cannot for the life of me get
> readline to work on the Windows version. If you use IPython, for
> example,
;>
>>> -Original Message-
>>> From: [EMAIL PROTECTED]
>>> [mailto:[EMAIL PROTECTED] On Behalf Of
>>> Magnus Hagander
>>> Sent: Saturday, August 04, 2007 3:09 PM
>>> To: nac1967
>>> Cc: [EMAIL PROTECTED]
>>> Subject: Re
On Mon, Aug 06, 2007 at 11:26:18AM +0200, Henrik Zagerholm wrote:
> Hi list,
>
> I'm running 8.2.4 and I've started to get these messages and even
> though I googled for some answers I couldn't find any good info
> against the 8.2 code base.
>
> 2007-08-05 04:00:58.815 CEST LOG: checkpoints
On Wed, Aug 08, 2007 at 01:03:54PM +0200, [EMAIL PROTECTED] wrote:
> Hi.
> Anybody know if is possible to install PostgreSQL in cluster mode on a
> cluster formed by two windows server 2003 cluster?
Yes. Set it up as a generic service, and make sure you store the data
directory (and any other tabl
onf, but nothing is
> changed.
>
> Luca
>
> - Original Message
> Da: Magnus Hagander <[EMAIL PROTECTED]>
> To:
> Cc: pgsql-general@postgresql.org
> Oggetto: Re: [GENERAL] PostgreSQL and cluster
> Data: 08/08
Trevor Talbot wrote:
> On 8/14/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote:
>
>> Let me fine tune my question here. What I mean to say is the way we can
>> write stored procedures in C, perl etc in Postgres specifying the language
>> parameter at the end of stored procedure, compared to tha
Harpreet Dhaliwal wrote:
> So you mean to say something like this as far as oracle is concerned:
>
> BEGIN
> DDL 1 (commits right after its execution)
> DDL 2 (commits right after its execution)
> END
>
> That means there's no concept of putting DDL statements in a transaction
> in or
On Fri, Aug 17, 2007 at 11:51:52PM +1000, Naz Gassiep wrote:
> I was wondering if there is any reason that accessing the system view
> pg_timezone_names is extremely slow relative to other queries. The
> following query:
>
>SELECT * FROM pg_timezone_names;
>
> Executes in between 29ms and 3
On Fri, Aug 17, 2007 at 04:19:57PM +0200, Hannes Dorbath wrote:
> On 17.08.2007 15:59, Tom Lane wrote:
> >On the other side of the coin, I have little confidence in DRBD
> >providing the storage semantics we need (in particular guaranteeing
> >write ordering). So that path doesn't sound exactly ri
Phoenix Kiula wrote:
> I am writing some simple batch scripts to login to the DB and do a
> pg_dump. Also, when I login to do my own SQL tinkering, I'd like not
> to be asked for a password every time (which, for silly corporate
> reasons, is quite a convoluted one).
>
> So I read up on .pgpass. W
Phoenix Kiula wrote:
> On 18/08/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>> Phoenix Kiula wrote:
>>> I am writing some simple batch scripts to login to the DB and do a
>>> pg_dump. Also, when I login to do my own SQL tinkering, I'd like not
>>&g
Phoenix Kiula wrote:
>
>
> Well based on some past posts, I looked into my pg_log stuff and found
> a number of these lines:
>
>
> [
> LOG: could not fork new process for connection: Resource temporarily
> unavailable
> LOG: could not fork new process for connection: Resource
Phoenix Kiula wrote:
> [Sorry for the length of this post. It stretched as I provided as much
> info as possible..]
>
> So the rubber meets the road. We've put postgresql in a production
> environment with some heavy simultaneous usage. It works well in
> general, but often PG doesn't respond. How
Muhyiddin A.M Hayat wrote:
> Dear all,
>
> i'm unable to connect postgres server with error :
>
> C:\Program Files\PostgreSQL\8.2\bin>psql -U postgres siakad
> Password for user postgres:
> psql: server closed the connection unexpectedly
> This probably means the server terminated abnor
Phoenix Kiula wrote:
> On 19/08/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>> Phoenix Kiula wrote:
>
> .snipped
>
>>> I can merrily increase the "max_fsm_pages" directive, but the manual
>>> also caveats that with "this can u
Phoenix Kiula wrote:
> On 19/08/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>> Phoenix Kiula wrote:
>
>> There are ways to do this, but if you can't just use timeouts to expire
>> from the cache, things can become pretty complicated pretty fast. But
>&
Phoenix Kiula wrote:
> On 19/08/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>> Phoenix Kiula wrote:
>>> On 19/08/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>
>
>>> should we do one (VACUUM FULL) now given that we've overrun our
>&g
Phoenix Kiula wrote:
> On 19/08/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>> Phoenix Kiula wrote:
>
> ...snip
>
>> There should be a line like this at the end of a "VACUUM VERBOSE" command:
>> INFO: free space map contains 33 pages in 74 re
Alvaro Herrera wrote:
> Terry Yapt wrote:
>
>> This is the main error:
>> * FATAL: could not reattach to shared memory (key=5432001, addr=01D8):
>> Invalid argument
>>
>> It is always followed by this another system-app error:
>> * LOG: unrecognized win32 error code: 487
>
> FWIW,
> http:/
Shelby Cain wrote:
>> - Original Message From: Magnus Hagander
>> <[EMAIL PROTECTED]> To: Alvaro Herrera
>> <[EMAIL PROTECTED]> Cc: Terry Yapt <[EMAIL PROTECTED]>;
>> pgsql-general@postgresql.org Sent: Thursday, August 23, 2007
>> 3:
Keaton Adams wrote:
> After reading several articles on the performance drag that Linux atime
> has on file systems we would like to mount our DB volumes with the
> noatime parameter to see just what type of a performance gain we will
> achieve. Does PostgreSQL use atime in any way when reading/wr
On Thu, Aug 30, 2007 at 02:07:13PM +0300, Idan Miller wrote:
> Hi everyone,
>
> I'm trying to configure PostgreSQL version 8.2.4 with Kerberos and Active
> Directory.
> The AD is run on a windows 2003 server, and the postgre on gentoo.
> The gentoo computer name is postgre and it's added to the wi
now, we are trying to connect from gentoo, but we want to connect from
> windows as well
>
> Idan
>
>
> On 8/30/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> >
> > On Thu, Aug 30, 2007 at 02:07:13PM +0300, Idan Miller wrote:
> > > Hi everyone,
>
2007 at 12:05:54PM +0300, Idan Miller wrote:
> Hi Magnus,
>
> I tried changing the SPN to uppercase POSTGRES, but still the same error
> occurs.
> Any other ideas? (this didn't work both locally and remotely).
>
> Idan.
>
>
> On 8/31/07, Magnus Hagander <[E
On Wed, Sep 19, 2007 at 09:10:43AM -0500, Walter Roeland wrote:
> Dave,
>
> For the reasons you mention for using pg_ctl -w, it seemed to me the wisest
> option to recreate the postgres database. After the normal startup messages,
> the following error appears once in the log:
>
> 127.0.0.1 pos
On Thu, Sep 20, 2007 at 04:33:25PM -0500, Scott Marlowe wrote:
> On 9/20/07, Robert Fitzpatrick <[EMAIL PROTECTED]> wrote:
> > On Thu, 2007-09-20 at 16:38 -0400, Bill Moran wrote:
> > > In response to Robert Fitzpatrick <[EMAIL PROTECTED]>:
> > > Why does everyone leave of the IO subsystem? It's a
Ron Johnson wrote:
> On 09/28/07 21:12, Tom Lane wrote:
>> Michael Fuhr <[EMAIL PROTECTED]> writes:
>>> No, it isn't. If you get UTF8 (formerly UNICODE) as a default then
>>> it's because initdb is picking it up from your environment.
>> Which initdb has done since 8.0. If the OP is such a rabid
On Sun, Sep 30, 2007 at 11:36:23PM +0200, Terry Yapt wrote:
> Hello all,
>
> I would like to change a pg database to another server.
>
> The source environment is: postgresql Windows v.8.2.4 (windows xp
> workstation).
> The target environment is: postgresql Windows v.8.2.5 (windows 2003 Server)
On Mon, Oct 01, 2007 at 11:38:53PM +0200, Terry Yapt wrote:
> Magnus Hagander escribió:
> >On Sun, Sep 30, 2007 at 11:36:23PM +0200, Terry Yapt wrote:
> >>First of all. I think this method is admisible. Isn't it ?
> >>
> >
> >It is.
> >
On Wed, Oct 03, 2007 at 11:18:32AM +0100, Richard Huxton wrote:
> Don't forget to cc: the list.
> Try not to top-post replies, it's easier to read if you reply below the
> text you're replying to.
>
> Sergey Konoplev wrote:
> >>1. Is it always the same query?
> >>2. Does the client still think it
> > I have Postgres 8.1.3 running on Windows XP. I keep seeing this error in
> > the log files:
>
> Update to 8.1.3.
I'm sure Alvaro means 8.1.10..
> Better yet, update to 8.2.5, as 8.1 is unsupported on Windows.
>
> http://www.postgresql.org/about/news.865
Since we haven't released 8.3 yet,
> Hi,
>
> Sorry for top-posting but since I am answering questions that don't all
> appear in this message:
>
> - I installed the default download of Postgres. I didn't compile myself,
> so it's probably the mingw version
It is.
> - Max_connections is set to 500. I did that originally because
On Wed, Oct 17, 2007 at 02:40:14AM -0400, Tom Lane wrote:
> "Magnus Hagander" <[EMAIL PROTECTED]> writes:
> >> - Max_connections is set to 500.
>
> > There's your problem. 500 is way above what the windows version can
> > handle. IIRC the hard
> > > Maybe we should put an #ifdef WIN32 into guc.c to limit
> > > max_connections to something we know the platform can stand? It'd
> > > be more comfortable if we understood exactly where the limit was,
> > > but I think I'd rather have an "I'm sorry Dave, I can't do that"
> > > than random-see
Tom Lane wrote:
> "Magnus Hagander" <[EMAIL PROTECTED]> writes:
>>> How about we just emit a warning..
>>>
>>> WARNING: Connections above 250 on Windows platforms may have
>>> unpredictable results.
>
>> That's probably a be
Trevor Talbot wrote:
> On 10/20/07, Rainer Bauer <[EMAIL PROTECTED]> wrote:
>
>> Anyway, the problem are the no. of semaphores created by Postgres:
>> Every backend creates at least 4* semaphores. Just
>> increase to an unusual high value (say 1) and
>> start creating new connections while mo
Trevor Talbot wrote:
> On 10/17/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>> On Wed, Oct 17, 2007 at 02:40:14AM -0400, Tom Lane wrote:
>
>>> Maybe we should put an #ifdef WIN32 into guc.c to limit max_connections
>>> to something we know the platform
On Sun, Oct 21, 2007 at 09:43:27PM +0200, Rainer Bauer wrote:
> Magnus Hagander wrote:
>
> >Trevor Talbot wrote:
> >> On 10/20/07, Rainer Bauer <[EMAIL PROTECTED]> wrote:
> >>
> >>> Anyway, the problem are the no. of semaphores created by
On Mon, Oct 22, 2007 at 10:23:16AM +0200, Magnus Hagander wrote:
> > >> I tried going up to 2 max_connections, and still blew postmaster's
> > >> VM space long before paged pool was exhausted. I couldn't test any
> > >> higher values, as there&
On Mon, Oct 22, 2007 at 10:41:14AM +0200, Magnus Hagander wrote:
> On Mon, Oct 22, 2007 at 10:23:16AM +0200, Magnus Hagander wrote:
> > > >> I tried going up to 2 max_connections, and still blew postmaster's
> > > >> VM space long before paged po
On Mon, Oct 22, 2007 at 04:03:35PM +0200, Rainer Bauer wrote:
> >> shared_buffers = 512MB
> >
> >As a general note, thsi is *way* too high. All evidence I've seen points to
> >that you should have shared_buffers as *small* as possible on win32,
> >because memory access there is slow. And leave more
On Mon, Oct 22, 2007 at 08:04:03AM -0700, Trevor Talbot wrote:
> On 10/22/07, Dave Page <[EMAIL PROTECTED]> wrote:
> > Dave Page wrote:
> > > So, we seem to be hitting two limits here - the desktop heap, and
> > > something else which is cluster-specific. Investigation continues...
> >
> > In furth
Dave Page wrote:
> Trevor Talbot wrote:
>> The question is where that's coming from. I wondered if it was
>> desktop heap originally, but there's no reason it should be using it,
>> and that seems to be precisely the difference between my system and
>> the others. Connections here are barely maki
Florian Weimer wrote:
> * Magnus Hagander:
>
>> Oh, that's interesting. That's actually a sideeffect of us increasing
>> the stack size for the postgres.exe executable in order to work on other
>> things. By default, it burns 1MB/thread, but ours will do 4
Trevor Talbot wrote:
> On 10/21/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>
>>> I tried generating idle connections in an effort to reproduce
>>> Laurent's problem, but I ran into a local limit instead: for each
>>> backend, postmaster creat
Dave Page wrote:
> Magnus Hagander wrote:
>> Could you try a build without SSPI? It should be as simple as removing
>> the #define ENABLE_SSPI 1 from port/win32.h. I don't think you need to
>> touch the linker lines at all, actually, so try without first.
>
>
Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
>> I was planning to make it even easier and let Windows do the job for us,
>> just using RegisterWaitForSingleObject(). Does the same - one thread per
>> 64 backends, but we don't have to deal with the
Rainer Bauer wrote:
> After increasing the session heap size in the registry from 512KB to 1024KB
> the no. of connections was roughly doubled. So this might be a solution for
> people running out of Desktop heap.
>
> Alter the value of the following key
>
>
> The numeric values following "Share
On Wed, Oct 24, 2007 at 03:06:03PM +0200, [EMAIL PROTECTED] wrote:
> Hi All.
> I've the necessity to call some functions of libpq.lib from my code. The
> problem is that my code is Managed C++ (as defined by Microsoft VisualStudio
> 2005). Managed C++ has a very special memory management and I don'
Roberts, Jon wrote:
> So the long story short I'm getting is, "no it is not on the radar". This
> is terribly ironic given the fact that pgAdmin is developed using source
> control but the code you write with the tool doesn't have any hooks into
> source control.
Actually, it is on my personal ra
dhiraj bhosale wrote:
> Hi,
>
> I would like to know if there is any kind of conflict or limitation
> occur between postgresql dll files for two different setups(different
> versions) in different data directories and running on two serepate
> ports. And if it has any conflict can anyone put some
On Tue, Nov 06, 2007 at 01:38:31AM -0800, Samantha Atkins wrote:
>
> On Nov 6, 2007, at 1:15 AM, Raymond O'Donnell wrote:
>
> >On 06/11/2007 08:54, Reg Me Please wrote:
> >
> >>What'd be the syntax to create a primary key on an already build
> >>table?
> >
> >ALTER TABLE test ADD CONSTRAINT tes
> > Does anyone know how to adjust the IPC settings in Windows?
>
> There aren't any such settings in Windows, AFAIK.
Correct. The only real adjustable limit is the size of the Windows pagefile,
but that one is normally dynamic. But there must be room for all the shared
memory in it. It's not
Kevin Neufeld wrote:
> That makes sense, thanx.
> Another individual was having problems adjusting the shared_memory
> settings higher than 1.2GB on a 8GB 64bit machine running Vista.
Pg on win32 is 32-bit. It has a total address space of 2Gb, minus the OS
overhead, minus the code, minus local me
Lee Keel wrote:
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:pgsql-general-
>> [EMAIL PROTECTED] On Behalf Of Magnus Hagander
>> Sent: Thursday, November 08, 2007 12:47 AM
>> To: Tom Lane
>> Cc: Kevin Neufeld; pgsql-general@postgresql.org
&g
1 - 100 of 998 matches
Mail list logo
