It honestly seems far more reasonable to me that %s and %I should do
the exact same thing with regclass. My reasoning is as follows:
‘%I’ formats a something such that it is a valid identifier,
regclass is already a valid identifier,
therefore, do nothing.
Another line of reasoning:
If you for
2015-03-14 10:09 GMT+01:00 Jason Dusek :
> It honestly seems far more reasonable to me that %s and %I should do
> the exact same thing with regclass. My reasoning is as follows:
>
> ‘%I’ formats a something such that it is a valid identifier,
>
> regclass is already a valid identifier,
>
> therefo
Hi Steven:
On Fri, Mar 13, 2015 at 9:03 PM, Steven Lembark wrote:
> > The thing is you can use desktop class machines for the slave. If you do
.
> If load on the backup server becomes an issue you might be able to
> make incremental pg_dump's onto tmpfs.
I'm curious, how do you make increme
Hi Robert:
On Thu, Mar 12, 2015 at 12:52 PM, Robert Inder wrote:
> On 11 March 2015 at 17:32, Francisco Olarte wrote:
>> This is, build an streaming replication slave, pg_dump from the slave. If
>> needed, restore in the master.
...
> I really like the idea of running pg_dump on the slave, but I
Jason Dusek writes:
> It honestly seems far more reasonable to me that %s and %I should do
> the exact same thing with regclass.
You're mistaken. The operation of format() is first to convert the
non-format arguments to text strings, using the output functions for their
data types, and then to f
On Saturday, March 14, 2015, Jason Dusek wrote:
> It honestly seems far more reasonable to me that %s and %I should do
> the exact same thing with regclass. My reasoning is as follows:
>
> ‘%I’ formats a something such that it is a valid identifier,
>
> regclass is already a valid identifier,
>
>
Greetings,
I have a table with 10s of millions of rows and I'm running a fairly
complex query with a lot of self joins.
This is an experimental db and the table structure needs to stay as it is.
I've noticed that some queries are not completed because postgres uses all
available space on disk for
hi all!
should we add disclaimer in pitr documentation about cp and fsync?
cp does not fsync.
and dd for example can do fsync.
-- misha
Seref Arikan writes:
> I have a table with 10s of millions of rows and I'm running a fairly
> complex query with a lot of self joins.
> This is an experimental db and the table structure needs to stay as it is.
> I've noticed that some queries are not completed because postgres uses all
> availab
On 14 March 2015 at 09:17, David G. Johnston wrote:
> On Saturday, March 14, 2015, Jason Dusek wrote:
>> It honestly seems far more reasonable to me that %s and %I should do
>> the exact same thing with regclass. My reasoning is as follows:
>>
>> ‘%I’ formats a something such that it is a valid i
2015-03-15 3:09 GMT+01:00 Jason Dusek :
> On 14 March 2015 at 09:17, David G. Johnston
> wrote:
> > On Saturday, March 14, 2015, Jason Dusek wrote:
> >> It honestly seems far more reasonable to me that %s and %I should do
> >> the exact same thing with regclass. My reasoning is as follows:
> >>
On Sat, Mar 14, 2015 at 8:29 AM, Tom Lane wrote:
> Jason Dusek writes:
> > It honestly seems far more reasonable to me that %s and %I should do
> > the exact same thing with regclass.
>
> You're mistaken. The operation of format() is first to convert the
> non-format arguments to text strings,
12 matches
Mail list logo
